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

vikas vikas.rosal at gmail.com
Fri May 25 06:52:21 PDT 2007


I am trying to execute the query that contains (single quotes in
criteria) on Oracle 9i Server , using Open Link but getting a Error
messages

SQL State = 01004
Native Error Code = 0
Error Message = [OpenLink][ODBC][Driver]Data was truncated

SQL State = 01004
Native Error Code = 0
Error Message = [OpenLink][ODBC][Driver]Data was truncated

SQL State = 01004
Native Error Code = 0
Error Message = [OpenLink][ODBC][Driver]Data was truncated

SQL State = 01004
Native Error Code = 0
Error Message = [OpenLink][ODBC][Driver]Data was truncated

SQL State = 37000
Native Error Code = 0
Error Message = [OpenLink][ODBC][Driver]Syntax error or access

Query Syntax is similar to below given query :

Select name,id from xyz where name = 'abc'

can anyone tell me the solution for given issue.

Thanks in Advance
Vikas







More information about the wx-users mailing list