Hi Experts,
I have written one program which handles some Tables containing Unicode Values.
I want to search those values by passing a Unicode Value.
What should I DO??
I have write following code, which seems to be right, but could not return any records.
Can you help..Its urgent..
I tried out various ways but dont work..
int Get_Match_Vocables(unsigned short *usFindVoc,CRecordset &recOut)
{
CDatabase cn;
CString FieldValue1,FieldValue2,FieldValue3;
CDBVariant varvalue;
CString sqlStr;
CString csPwd,csUser,csServer,csDBName;
csPwd = "SQLServer2005";
csUser = "sa";
csDBName = "DeccanCollege";
csServer = "DECCANSERVER";
cn.OpenEx(_T("DRIVER={SQL Server};Pwd="+csPwd+";Uid="+csUser +";Database="+csDBName+";Server="+csServer),CDatabase::noOdbcDialog);
CRecordset rec(&cn);
sqlStr = "Select * from Vocablemaster where slvid in(Select slvid from slipvocmaster where binno between 165 and 169) and (VocDescSan like N'%"+CString(usFindVoc)+"%')";
rec.Open( CRecordset::forwardOnly,sqlStr,CRecordset::none);
while(!rec.IsEOF())
{
rec.GetFieldValue((short)0,FieldValue1);
rec.GetFieldValue((short)1,FieldValue2);
rec.GetFieldValue((short)2,FieldValue3);
rec.MoveNext();
}
return (int)rec.GetRecordCount() ;
}
In above code, usFindVoc is Unicode value, passed to this function.
When I checked its HEX value, it is correct which I have sent to it.
Please help .. if any mistakes then please suggest the corrections..
Thanks...
.....Victory...........