I am just starting to work with ADO and VFP. I am having a problem changing the values in the record set created from a Free Table. The error I am getting is... the Operation Requested is not supported by the provider. The provider is
oConnection = CREATEOBJECT("adodb.connection")
lcCon="Driver={Microsoft Visual FoxPro Driver};UID=;PWD=;"+ ;
"SourceDB="+"c:\test\mydbf.dbf;"+ ;
"SourceType=DBF;Exclusive=no;BackgroundFetch=No;Collate=Machine;"
oConnection.OPEN(lcCon)
oRecordSet = CREATEOBJECT("adodb.recordset")
oRecordSet.OPEN([Select * From c:\test\mydbf Where mydbf.test1 = "Old Value"],oConnection)
I am trying to change a value by
oRecordSet.FIELDS("test1").value = 'New Value'

Any Idea what I am doing wrong?

Thanks in advance.

Bob