General information
Category:
COM/DCOM and OLE Automation
Title:
A problem with VFPCom.ComUtil
I am having a trouble with the CursorToRS() function of VFPCom.DLL. The RsToCursor() don't transform the none English string, such as "¤¤°ê" Chinese character set, the cursor result is a string of space only.
I don't know what happen with it ?
If you knownd please tell me & thanks very much!
Attached the foxpro code:
#DEFINE C_VFPCOMCLASS 'vfpcom.comutil'
oVFPCOM = CreateObject(C_VFPCOMCLASS)
oRecordSet = CreateObject('ADODB.RECORDSET')
oRecordSet.CursorType = 3 && adOpenStatic Also adOpenForwardOnly
oRecordSet.LockType = 1 && adLockReadOnly
oRecordSet.Open('SELECT name FROM employee ', + ;
'Provider=SQLOLEDB;Password=123;Persist Security Info=True;User ID=usr;Initial Catalog=db_test;Data Source=sqlsvr') && the name is chinese name.
nError = oVFPCOM.RSToCursor(oRecordSet,"employee")
BROWSE
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only