>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
Do you have a good reason not to use SPT instead ?
Cetin