Just to make sure I'm on the right track still, how does this sound:

I use ADO to get a record set from a SQL Server database (VFP7). I convert the RS to a cursor which I use for all the usual stuff in my code.

Now the user modifies a record - do I search the RS for the matching record, change the appropriate field values, and do an update (of the whole record set)?

Is there an easy way to delete and add a record to a RS?

Thanks,
Pat