MUSHclient scripting

Description of MUSHclient world function: world.DatabaseChanges

Name	DatabaseChanges
Type	Method
Summary	Returns a count of the changes to the database by the most recent SQL statement
Prototype	`long DatabaseChanges(BSTR DbName);` View list of data type meanings
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. Note: Available in version 4.40 onwards.
Lua example	`changes = DatabaseChanges ("db")`
Returns	`A positive integer, or zero, indicating the count of changes. Otherwise: -1 : Database id not found -2 : Database not open`
Introduced in version	4.40

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

Enter a word or phrase in the box below to narrow the list down to those that match.

The function name, prototype, summary, and description are searched.

Leave blank to show all functions.

Many functions return a "code" which indicates the success or otherwise of the function.

The "prototype" part of each function description lists exactly how the function is called (what arguments, if any, to pass to it).

Information and images on this site are licensed under the Creative Commons Attribution 3.0 Australia License unless stated otherwise.