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()
Everything makes sense in someone's mind
public class SystemCrasher :ICrashable
In addition, an integer field is not for irrational people