world.DatabaseColumnValue
Returns the contents of an SQL column, as text, float, integer, or null
Prototype
VARIANT DatabaseColumnValue(BSTR DbName, long Column);Description
You can use this, after successfully doing a DatabaseStep, to get the data in a particular column, in the appropriate format: text, floating point number, integer or null.
Columns start at 1 for the first column, up to the number returned by DatabaseColumns.
Lua example
x = DatabaseColumnValue ("db", 2) --> the contents of column 2Lua notes
Lua returns nil for a NULL value.
Return value
The contents of the column, as a string, long, double or empty variant.
Returns the null variant if there is an error, such as invalid database id, no current row, etc.
Related topic
See also
| Function | Description |
|---|---|
| DatabaseColumnName | Find the name of a specified column returned by an SQL statement |
| DatabaseColumnNames | Return a table of all the columns returned by an SQL statement |
| DatabaseColumnText | Returns the contents of an SQL column, as text |
| DatabaseColumnType | Returns the type of data in an SQL column |
| DatabaseColumnValues | Returns the contents of all the SQL columns after a step |
| DatabaseColumns | Find how many columns will be returned by an SQL statement |
| DatabaseError | Returns an English string describing the most recent SQL error |
| DatabaseExec | Executes SQL code against an SQLite database |
| DatabaseFinalize | Finalizes (wraps up) a previously-prepared SQL statement |
| DatabaseLastInsertRowid | Returns the most recently automatically allocated database key |
| DatabaseOpen | Opens an SQLite database |
| DatabasePrepare | Prepares an SQL statement for execution |
| DatabaseReset | Resets a previously-prepared SQL statement to the start |