SQL > SQL query Field Types

Field types when using the SQL Editor

The PdxEditor uses the data or field types supplied by the BDE.

Creating tables or creating derived output fields in SELECT queries

Some field types are not compatible with some of the table formats or of some early versions/levels of the targeted table(s).
E.g. BCD fields are available in Paradox 5 & 7 but not available in neither dBASE nor FoxPro of any version.
The integer type Short is available only for Paradox tables, and the data type Long was not introduced in Paradox until version 5 (1994) and in dBASE with version 7 (1997).
Please see the individual table formats - Paradox table format and dBASE table format.

Field types compatible across the table formats translates as necessary and as best fitted into native field types of the target tables.
For instance NUMERIC(4) may translate into the SMALLINTEGER type Short i Paradox whereas NUMERIC(6) may translate into Integer in Paradox.
Also NUMERIC and FLOAT may translate into the more favourable Double when creating dBASE 7 tables.