Register forum user name Search FAQ

MUSHclient scripting

Description of MUSHclient world function: world.DatabaseLastInsertRowid


Name DatabaseLastInsertRowid
Type Method
Summary Returns the most recently automatically allocated database key
Prototype BSTR DatabaseLastInsertRowid(BSTR DbName);
Description

This returns a string which is the most recent automatically allocated database key (for example, if you are using autoincrement on the primary key). Internally it is a 64-bit number, but since there is no ready mechanism for returning 64-bit numbers via the scripting interface, MUSHclient converts it to a string, and returns that.


Note: Available in version 4.40 onwards.


Lua example
last_key = DatabaseLastInsertRowid ("db")
Returns A string which is the most recently-allocated key. May be zero if there is no such key.
Introduced in version 4.40

See also ...

Function Description
DatabaseChanges Returns a count of the changes to the database by the most recent SQL statement
DatabaseExec Executes SQL code against an SQLite database
DatabaseStep Executes a previously-prepared SQL statement
DatabaseTotalChanges Returns a count of the total changes to the database

Search for script function

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.

Search for:   

Leave blank to show all functions.


Return codes

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

You can view a list of the return codes


Function prototypes

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

You can view a list of the data types used in function prototypes


View all functions

[Back]

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