<< Click to Display Table of Contents >> Navigation: ThinBASIC Modules > SQLite > SQLite_GetRow |
Description
Gets the next selected row of fields for set passed in SetNumber.
Syntax
n = SQLite_GetRow[(lSetNumber [, sModificators])]
Returns
Number.
Returns %True if there is a next row available.
Returns %False if no row is available (end of set) and will close the set.
Parameters
Name |
Type |
Optional |
Meaning |
lSetNumber |
Number |
Yes |
SetNumber can be omitted or be any value from 0 to 32767. If omitted then will use zero. Since SetNumber is used as an array index, no gaps is best, which will result in a smaller array. You can have as many unique sets open/active at same time as your memory will allow. |
sModificators |
String |
Yes |
ModChars is a string with flags. Below possible options: C = Create if not there. Ignored if ReadOnly. Em = Return errors. This will override the global return errors flag. m is the optional message display modifier and can be: 0 = No message is displayed. This is the default. 1 = Display a warning message with OK button. Error is returned when OK pressed. 2 = Display a question message with OK and Cancel buttons. If they press OK, error is returned. If they press Cancel, will exit process. e = Do not return errors, display message and exit process. This will override the global return errors flag. f = Do not enable foreign key support. If 'f' is passed then will send: PRAGMA foreign_keys=Off If 'f' is not passed then will send: PRAGMA foreign_keys=On R = Will pass the ReadOnly attribute to SQLite. You will not be able to update the database. Never use with inherited handles. Tn = Where n is milliseconds to wait for a database lock. Default is 10000 milliseconds (10 seconds). |
Remarks
Restrictions
See also
Examples