John Hi,
Here is another problem with ADO using VFP DBF's.
I execute an Rs.Open "SELECT " statement and get a record set.
I then update most fields only one record from that recordest and perform an Rs.Update.
If the record set happens to contain more than one record that are exactly the same (for example all fields are blank), then all the records are updated and thereby I get duplicates in the table even though my intention was to change only one record.
I believe that this may have something to do with the fact that the OLE-DB provider (in this case MS VFP) does not support bookmarks (or record numbers in this case).
Am I correct in this assesment and is there a workaround?
Thanks
Costas