Hi

I want to connect to SQL 2005 to retrieve data into VFP, but I'd like the cursor within VFP to be updatable within SQL. The issue is that I'd like the record locking/updating to be handled natively within SQL 2005, and as some of the tables have a large number of fields, the idea of using the UpdatableFieldList seems very long-winded when you could have 400-500 fields in said table??!?!

I like the idea of pass-through as I can run stored procedures from SQL 2005, and in reality, I'd prefer to keep as many of the SQL statements native to SQL 2005. VFP is only really used to tie the cursor fields to their respective fields on a form, and then call the update or revert procedure to save/discard any changes to the data.

Any ideas?

Regards