I'm trying to get information about specific field in VB6 but when the field is consists of characters in hebrew, I'm not getting data.
The Code is:
Dim oSBObob As SAPbobsCOM.SBObob Dim oRecStock As SAPbobsCOM.Recordset Dim str As String Set oSBObob = oCompany.GetBusinessObject(BoBridge) Set oRecStock = oCompany.GetBusinessObject(BoRecordset) str = "Select OnHand from OITW where ItemCode = 'בנק'" oRecStock.DoQuery (str)
I am getting oRecStock.EOF = true although the record exists.
but when the string is :
str = "Select OnHand from OITW where ItemCode = 'ABC'"
, I am getting results.
What is the reason, Why there is difference between the languages and what can I do in order to solve this?