I've got a query of the form SELECT name FROM customer WHERE inactive=False in Access 97. This worked fine in Access, and works in the SQL studio to SAPdb (Version 7.4.3). From Access to SAPdb using ODBC, I get Error 8006 Data types must be compatible.
The SQL trace of the ODBC driver shows that the boolean test is being passed through as '... "INACTIVE" = 0'. This suggests that it's an ODBC problem. Similarly, inactive <> true is passed through as NOT INACTIVE = 1. I'm using version 7.4 of the ODBC driver, with the 7.3 version of the driver, to avoid the Unicode bug with the ODBC driver (Ie, that 7.4 only supports Unicode, win98 doesn't support Unicode, and 7.3 doesn't work with MS Access). I've tried both INTERNAL and ANSI modes of the ODBC driver, with the same result, ie, False is transfered as '0' and True as 1. I've googled for this, and found a few people with the same problem, but no answers that work for me. I got excited about the answer that suggested that Access doesn't like nulls in Boolean fileds, but I don't have any nulls. All tuples have the values TRUE or FALSE. Then I found the suggestion that Access wasn't recognising the column as a type 'Yes/no'. I checked that, and it is. The column is handled correctly on forms, etc, as a checkbox where appropriate. It only seems to be a problem in the where clause. Can anyone shed any light on this? Regards Alan Graham _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
