When using dBASE ODBC driver, having a TBooleanField in TFDTable, FireDAC generates SQL command like this when calling CreateTable:
CREATE TABLE MyTable (
MyLogicalField BOOLEAN
)
instead of:
CREATE TABLE MyTable (
MyLogicalField LOGICAL
)
What can I do to get correct result? I cannot read FireDAC source, have only older version with source by hand. Could you point me how this command is generated and optionally how to map TBooleanField to LOGICAL data type?
dBASE data type LOGICAL is mapped to SQL_BIT, so the point is why that data type is not used when generating CREATE command.
[dBASE data types|https://docs.microsoft.com/en-us/sql/odbc/microsoft/dbase-data-types]
Is e.g. SQLGetTypeInfo ODBC function used, or the command is generated purely by FireDAC?
Connect with Us