SQLite_GetRow

<< 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