Count the results of an SQLite update

Databases
1

Hi,

One of my programs can perform a mass delete or updates in SQLite. I’d like to tell the user the number of rows updated or deleted. SQLite records this information and you can retrieve it with

int sqlite3_changes(sqlite3*);

However not being anything like an SQL expert, how do I get that back into Xojo.

Thanks
Jack
2

You’ll have to do a separate query for now using the same where clause. I also suggest making a feature request though.

3

Thanks.

Have created a feature request. #80702

jack