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

Version | Status | Notes
10.0 | No Change | Carried over from Panorama 6.0.