the problem is when i create a query with a boolean column in the
where-clause something (access? or the odbc-driver?) converts the "true" into 1 and the
database can't compare boolean with 1. How can i solve this problem? Is it
possible to handle this in the odbc-driver? Otherwise is it possible to learn
sapdb to compare boolean to integer? Or can i change any settings in access,
the odbc-driver or sapdb?
the sqltrace looks like this:
S3:SELECT "DBA_ARTIKEL"."ID" FROM "DBA"."ARTIKEL" "DBA_ARTIKEL" WHERE
("VORMERKEN" = 1 )
PARSE : CMD :
SQLCODE: -8006 Data types must be compatible
PARSEID: OUTPUT: 00000000 00000000 00000000 00000000
SQLERRD(INDEX_6) : 83 ERROR NEAR ^ : MERKEN" = ^1 )
START : DATE : 2002-09-30 TIME : 0022:34:08
END : DATE : 2002-09-30 TIME : 0022:34:08
S3: DISCONNECT
--
Werden Sie mit uns zum "OnlineStar 2002"! Jetzt GMX w�hlen -
und tolle Preise absahnen! http://www.onlinestar.de
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
