Hi,
I am quite sure you are using Jet/ODBC with linked tables. In that case use
queries like this one:
SELECT * FROM ATable WHERE ABooleanField = cbool(TRUE)
Yves
-----Original Message-----
From: sapdb.general-admin@stripped
[mailto:sapdb.general-admin@stripped]On Behalf Of
heinrichulrich@stripped
Sent: 30 septembre, 2002 16:42
To: sapdb.general@stripped
Subject: ODBC/Access with boolean-column in where-clause
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
sapdb.general@stripped
http://listserv.sap.com/mailman/listinfo/sapdb.general
