#SqlChanges

VariableSQLRead-onlyNumberNew in Reforged

Set by: SQL, sql Delete, sql Exec, sql Load, sql Query, sql Save

#SqlChanges is the number of rows inserted, updated or deleted by the last sql exec or sql query.

After sql save, sql load or sql delete it is the number of variables saved, found or removed.

Example

sql open :memory:
sql exec CREATE TABLE loot(item TEXT, at INTEGER)
sql exec INSERT INTO loot VALUES('gold', 100), ('gem', 200), ('arrow', 300)
set %cutoff 250
sql exec DELETE FROM loot WHERE at < %cutoff
display ok Removed #SqlChanges old entries.
halt

See also