Field Type

The type of the column.

Supported By

• SQL Drivers (SQL Server, DB2, and ODBC)
• DataFlex Pervasive.SQL Driver

Value

• ASCII
• BCD
• BINARY
• DATE
• TEXT
• OVERLAP*

Associated Attribute

• DF_FIELD_TYPE (Enum list)

Remarks

Sets the data-type information for a field. This is used with Pervasive.SQL, for example, when we want to mark a field as a DataFlex Overlap* field because, according to Pervasive.SQL, those fields are just string fields. This is because Pervasive.SQL doesn't support the Overlap field type. It is used with the SQL Drivers to determine if a SQL_DateTime type should be mapped to a DataFlex Date or DateTime type.

Note

Overlap columns were replaced by multi-segment relationships in DataFlex 11.0 and are obsolete.

See Also

• Column Keywords