fieldtypes
DATABASE
,
RESULT

The fieldtypes statement returns a carriage return delimited array with list of fields and field data types.


Parameters

This statement has two parameters:

database – Database that you want list of field types for, or "" for current database.

result – Field or variable for result.


Description

This statement returns a carriage return delimited array with a list of the fields and field data types. Each line returned is in this format:

FIELDNAME tab() FIELDTYPE[numericfieldtype]

Here is an example of how this could be used:

local fieldInfo
FieldTypes "Checkbook",fieldInfo

This will fill the fieldInfo variable with something like this:

Check¬NUMERIC[6]
Date¬DATE[4]
PayTo¬TEXT[0]
Debit¬NUMERIC[5]

See Also


History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.