(OpenLink + wxWidgets )Database Query issue with single quotes in where clause

[Thomas Zehbe]

Hi,

Am Montag, 28. Mai 2007 07:11 schrieb vikas:
> i forgot to write table opening code here but its there in code &
> stilll its not working.its working fine for queries that dont have
> single quotes but as soon as criteria of strings is added ie we use
> single quotes it stops working.
>
> Query Syntax is similar to below given query :
> Select name,employer from XYZ where name = 'abc'
>          Query is not executing because where clause used in query has
> quotes bt when i try to execute query like
>
>          Select name,employer from XYZ where id=16 it executes fine
>
>          thats why i conclude that there is some problem with single
> quotes usage on MAC+Open Link combination

I've no experience with MAC+Open Link, only with Linux/msw and PostgreSQL. So 
I've only general hints:
- try another way using SetWhereClause(_T("name = 'abs'")); and Query();
- check how the string arives at the oracle server using logging facilitis.
- check encoding of string at client and server to be the same ... (utf-8 vs. 
ascii)
last but not least:
- use a debugger to step into query an see what happens.

Regards,
Thomas



-- 
Dipl.-Ing. Thomas Zehbe
INGENION GmbH
Kuhweide 6
31552 Apelern
Fon: 05043 / 40 57 90 4
Fax: 05043 / 40 57 90 7
www.ingenion.de