Storing and retrieving data from a SQL database
paul at researchware.com
Sat May 21 03:33:02 CEST 2016
Apparently, you either DO need to escape certain characters even when
using parametrized queries.
I have the code below: I pass it an array where the description
pArray contains several lines of text from a field and the second
line contains a tab
command updateInDatabase pArray
put the databaseID of this stack into tDatabaseID
put "UPDATE mytable SET
id=:1" into tQuery
get the result
if it is not a number then
-- number of rows changed
This executes and indicates a row was update in the database and a
direct check of the SQLite database shows that columns were updated
EXCEPT for description where any content that was in pArray AFTER and
including the TAB is missing. So apparently TABs can not be included in
data passed by parameters.
OR is this a LiveCode 8 bug?
More information about the use-livecode