|
DBF Output Files
When Output Type=DBF, The result of the SQL query will be put on a standard DB3 database.
DBF tables have some limits on the field names, so the source field names will be translated using the following rules:
- Only the first 10 characters of the source field name will be used.
For example: The SQL field LongFieldName will be traslated on the DBF field: LONGFIELDN
- A DBF field name can't contain spaces, so they will be translated in "_"
For example: The SQL field Long Field Name will be traslated on the DBF field: LONG_FIELD
So, if you want to store a SQL query on a DBF database and the query have 2 fields which are similar, you have to assure your SQL command will generate a correct output table.
For example, the Query: Select "My Customer Name","My Customer Surname" from Customers is not correct because ODBC 4 ALL will try to generate a DBF table with 2 fields: MY_CUSTOME
To correctly create your DBF table you have to change your SQL query as: Select "My Customer Name" AS Name,"My Customer Surname" AS Surname from Customers
If a field on the SQL table contains the NULL value, the corresponding DBF field will contain the field's empty value.
An SQL DateTime field will be translated in a DBF Date field, loosing the time information. Once again, you can write your SQL query to store the time part in a new string field.
| 
