Next question: I'm getting an error, "The provider is not capable of
performing the requested operation". The code works fine for retreiving
records, but errors when I try to Update. My code is:


#INCLUDE Ado.h

CLEAR

LOCAL cDataPath, cConnString, oConnection, oRecordSet

cConnString = "Provider=VFPOLEDB.1;Data Source=d:\;"
oConnection = CREATEOBJECT("ADODB.Connection")
oConnection.ConnectionString = cConnString
oConnection.Open()

oRecordSet = CREATEOBJECT("ADODB.RecordSet")
oRecordSet.ActiveConnection = oConnection
oRecordSet.CursorType = adOpenDynamic
oRecordSet.LockType = adLockOptimistic

oRecordSet.Open("Test1")

oRecordSet.MoveFirst
oRecordSet.Fields(0).Value = "TEST"
oRecordSet.Update()