mysql and anonymous db errors

Mark Wieder mwieder at ahsoftware.net
Mon Aug 27 16:41:41 EDT 2012


Andre Garzia <andre at ...> 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







More information about the Use-livecode mailing list