world.DatabaseChanges
Returns a count of the changes to the database by the most recent SQL statement
Prototype
long DatabaseChanges(BSTR DbName);Description
This function returns the number of database rows that were changed or inserted or deleted by the most recently completed SQL statement on the database connection specified by the first parameter. Only changes that are directly specified by the INSERT, UPDATE, or DELETE statement are counted. Auxiliary changes caused by triggers are not counted. Use the DatabaseTotalChanges function to find the total number of changes including changes caused by triggers.
Lua example
changes = DatabaseChanges ("db")Return value
A positive integer, or zero, indicating the count of changes.
Otherwise:
-1 : Database id not found
-2 : Database not open
Related topic
See also
| Function | Description |
|---|---|
| DatabaseExec | Executes SQL code against an SQLite database |
| DatabaseLastInsertRowid | Returns the most recently automatically allocated database key |
| DatabaseStep | Executes a previously-prepared SQL statement |
| DatabaseTotalChanges | Returns a count of the total changes to the database |