fieldtypes(
DATABASE
)

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


Parameters

This function has one parameter:

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


Description

This statement returns a carriage return delimited array with list of 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:

fieldtypes("Checkbook")

This will return data something like this:

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

History

VersionStatusNotes
10.0No ChangeCarried over from Panorama 6.0.