Click above to get retro games delivered to your door ever month!

FIELDTYPE()

Syntax:     FIELDTYPE(<expN>)

Arguments:  <expN> denotes the field number to evaluate.

Returns:    A character string.
            If the field number was valid, the character returned denotes
            the type of field.  FIELDTYPE() will return the following
            characters for the different data types:

            Character   Data type
            ---------   ---------
              C         String
              N         Numeric
              D         Date
              L         Logic
              M         Memo

Usage:      FIELDTYPE() operates similarly to the Clipper function
            TYPE(), but uses the field number instead of the field name.
            The function can be used to determine data types for fields,
            when a generic program is operating on databases where
            the field name are not known.

Notes:      The function will return a null string if the field number is
            negative or out of range.

Library:    CT1.LIB


--------------------------------- Example ------------------------------

Examples:   * The data type for field 5.
            IF FIELDTYPE(5) = "C"
               ? "Field 5 is a character field."
            ENDIF