[unixODBC-support] unixODBC+MDBTOOLS+ACCESS : Problem with WHERE conditions

Eric Sharkey sharkey at netrics.com
Fri Jan 21 14:41:50 GMT 2005


> It is not a syntax problem because this query works perfectly in ACCESS. 
> I tried to log the connection :

Are you sure?

> [ODBC][3738][SQLExecDirect.c][233]
>                 Entry:
>                         Statement = 0x8102800
>                         SQL = [SELECT XDATE FROM ListePropositions WHERE 
> ListePropositions].REVISION="00"][length = 76 (SQL_NTS)]
> [ODBC][3738][SQLExecDirect.c][496]
>                 Exit:[SQL_ERROR]
>                 DIAG [08001] Couldn't parse SQL

It looks odd. Why do you have a "]" between the table name and the
column name?

Eric



More information about the unixODBC-support mailing list