Andre Garzia <andre@...> writes:

> It depends, on 5.5.1 I am receiving back 0 from RevExecuteSQL with a DELETE
> call that removes 12 records on a SQLite database... then in this case 0
> apparently means success and not the amount of records deleted.

"Prior to SQLite version 3.6.5, the truncate optimization also meant that the
sqlite3_changes() and sqlite3_total_changes() interfaces and the count_changes
pragma will not actually return the number of deleted rows. That problem has
been fixed as of version 3.6.5."

https://www.sqlite.org/lang_delete.html

-- 
 Mark Wieder
 ahsoftware.net




_______________________________________________
use-livecode mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription 
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode

Reply via email to