|
|
|
A new feature was added to allow a query from Microsoft Excel and ODBC on tables containing fields identified with FairCom DB SQL reserved keywords. The FairCom DB SQL ODBC Driver now considers field names preceded by a table name (i.e. tablename.fieldname) as a valid field even when they are reserved keywords. This is done by automatically wrapping the qualified fieldname in double quotes, which has the effect of making it case-sensitive. Because this behavior only applies to qualified identifiers it can be avoided by specifying only the fieldname without the tablename.
To use this particular feature with Microsoft Excel and the FairCom DB SQL ODBC Driver, a data source should specify the string “DHQQI” in the new Options field of the Data Source Configuration window. This will turn on this special processing for only this connection.
