|
|
Choosing A Webhost: |
ODBC/Access with boolean-column in where-clause: msg#00585db.sapdb.general
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
|
|
| <Prev in Thread] | Current Thread | [Next in Thread> |
|---|---|---|
| Previous by Date: | Newbie Create Database, Ralph Hulslander |
|---|---|
| Next by Date: | Re: need help with ERR_IMPERSONATE, Daniel Dittmar |
| Previous by Thread: | Newbie Create Database, Ralph Hulslander |
| Next by Thread: | RE: ODBC/Access with boolean-column in where-clause, Yves Trudeau |
| Indexes: | [Date] [Thread] [Top] [All Lists] |
Free MagazinesCisco NewsReceive a free quarterly e-newsletter with exclusive articles on how Cisco IT uses its own products and solutions to enable the business. subscribe Systems Management News, the newspaper for IT systems administration and data center managers! Each issue of Systems Management News is chock-full of news and analysis to help you understand what's happening in your field. subscribe The Enterprise Newsweekly eWeek is the essential technology information source for builders of e-business. subscribe Oracle Magazine Oracle Magazine contains technology strategy articles, sample code, tips, Oracle and partner news, how to articles for developers and DBAs, and more. Oracle (NASDAQ: ORCL) is the world's largest enterprise software company. subscribe Total Telecom Total Telecom is "The Economist of the communications industry". subscribe |