>I am using VFP 5.0
>
>Updateable view is created using multiple tables. Buffer mode is set to 5.
>View's Updatation criteria saves data only in one table.
>
>It takes very long time to complete the save operation!
>
>TIA
If you don't need conflict detection, in the View designer set "SQL Where clause includes:" to "Key Fields Only". If using a SQL database, set to "Key and Timestamp" which allows for some conflict detection, but is much faster than "Key and Updatable Fields" or "Key and Modified Fields". The more columns you have in your tables, the more this setting becomes a performance factor.
However, if you use "Key and Updatable" or "Key and Modified" then under View-Advanced Options dialog, uncheck "Fetch Memo" and/or "Include Memo Fields in WHERE Clause" Taking memo fields out of the comparison can greatly speed things up.
- Bruce
"Problems cannot be solved at the same level of awareness that created them." - Albert Einstein
Bruce Allen
NTX Data