Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
ADO Question
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00616353
Message ID:
00616783
Views:
27
This message has been marked as the solution to the initial question of the thread.
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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform