thinBasic Help Manual

Name

Type

Optional

Meaning

nColumnNumber

Number

No

First parameter cen be either a numeric expression or a string expression.

•If numeric: it will interpreted as "field number"

•If string: it will interpreted as "field name"

sFieldName

String

No

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:
 

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.

     If an error occurs then the return value will be an empty string.

e  = Do not return errors, display message and exit process. This

    will override the global return errors flag.

N  = Return NULL fields as $NUL.  CAUTION: You can not distinguish

    between a true NULL field and one that contains a single

    $NUL char.

D  = Decrypt.

U  = Uncompress.

t  = If field is DateTime then do not return time.

z  = If field is DateTime then do not return time if zero.

d  = If field is DateTime then do not return date.

y  = If field is DateTime then return empty if time is zero.

                 *** CAUTION ***                                      

        Requesting to uncompress a field that is not compressed       

        will cause unpredicable results!