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