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

[vikas]

I would like to add more info about the given issue

1. I am using XCode on macintosh

Code Snippet is given below

Query Syntax is similar to below given query :
Select name,employer from XYZ where name = 'abc'

wxDbTable BaseTable(ptrDB, wxT("XYZ"), 53, (const wxString
&)wxEmptyString, wxDB_QUERY_ONLY);

BaseTable.SetColDefs(0,	wxT("name")	  ,DB_DATA_TYPE_VARCHAR	  ,
arrName	   , SQL_C_WXCHAR  , 19*sizeof(wxChar)	, true, true);
BaseTable.SetColDefs(1,	wxT("employer")	 ,DB_DATA_TYPE_VARCHAR	 ,
arrEmployer	, SQL_C_WXCHAR	, 41*sizeof(wxChar)   , true, true);

if (!BaseTable.QueryBySqlStmt(strQuery))
{
         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

         Can anyone help me out on this.
}

Thanks again!!!