>>I'm on VFP 7.0. No CursorAdapters in VFP 7 right? Currently my application doesn't use a database container. Do you think I should go through the work of setting up a database and using remote views instead of SQL Pass-thru. Since most of the updates will be less than 500 records, will SQL Pass-thru with scanning the cursor and doing INSERTS not be efficient enough? Will I experience an enormous drop in peformance?
>
>I think scanning 500 records and then sending 500 inserts as one batch (using execute ('insert ...') syntax) should be quick enough.
>
>You can switch to remote views, but I don't have experience with remote views. With remote views you don't have to write extra code.
Thank you Naomi. After getting your opinion, I think I'm going to stick with the SQL Pass-thru and head down the road of building my INSERT statements in code.
You and Sergey are always out here at the right time and very helpful.
Thanks again.