Make recordset clien side
oRs.CursorLocation = ADUSECLIENT
>I don't see whats wrong here. Here's the program:
>
>#INCLUDE Ado.h
>
>CLEAR
>
>LOCAL cDataPath, cConnString, oConnection, oRecordSet
>
>cDataPath = "d:\"
>
>cConnString = "Provider=VFPOLEDB.1;Data Source=" + cDataPath + ";Mode=ReadWrite|Share Deny None;"
>
>oConnection = CREATEOBJECT("ADODB.Connection")
>oConnection.ConnectionString = cConnString
>oConnection.Open()
>
>oRecordSet = CREATEOBJECT("ADODB.RecordSet")
>oRecordSet.ActiveConnection = oConnection
>oRecordSet.CursorType = adOpenStatic
>oRecordSet.LockType = adLockOptimistic
>oRecordSet.Open("Test1")
>
>oRecordSet.MoveFirst
>oRecordSet.Fields(0).Value = "TEST"
>oRecordSet.Update()
>
>
--sb--
