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

4

Using

SELECT changes();

Does same as

int sqlite3_changes(sqlite3*);

So you perfectly can do it without any feature request or any new feature added to Xojo.

4 Likes
5

is there the same function for postgresql ? I didn’t find one.

6

Thank you, I will give that a try.

Jack

7

Yes there is, see:

You need to wrap your update statement in a PLPGSQL-function. I’m doing that a lot and it works great.

8

Why not use the RETURNING function:

SQL = "DELETE FROM myTable WHERE myField = 'Something' RETURNING id"

You can use RETURNING with UPDATE as well.

9

That works. Thank you.