dBASE IV/5 to 7 propagation

Field types after dBASE VI/5 to level 7 propagation

As mentioned elsewhere, when dBASE IV/5 tables are propagated to level 7 tables due to adding the Required attribute to selected fields, or if the table is created with the PRIMARY KEY (fieldname) within a CREATE TABLE statement, the fields defined as NUMERIC (whatever dimentioned as integer or float fields) will stay as this NUMERIC type, and will NOT convert into the otherwise default dBASE 7 numeric field types Double or Long for float and integer values respectively.

Saving SQL query result

When using the method Export/Save Current Query Result ... on dBASE 4 tables, the resulting table table if propagated to dBASE 7, the numeric fields specified as NUMERIC(s,p) will be propagated to the available binary field types Long and Float.