Panorama > Formulas > Database Functions
 
fieldtypes(
fieldtypes(
DATABASE
)

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

Parameters

This function has one parameter:

database – Database that you want a list of field types for, or “” for current database.

Description

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