Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
TableUpdate() is taking 5 minutes to save data (VFP 5).
Message
From
16/05/2000 09:36:40
 
 
To
15/05/2000 15:15:04
Diptesh Patel
Unitelsoftware Ltd.
Mumbai, India
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
00369744
Message ID:
00369914
Views:
27
How many records are in the table you are updating?
Do you have an index tag on DELETED() and if so, is SET DELETED ON.

We ran into a similair problem like this when issuing TABLEUPDATE() on a large table with an index on DELETED() and SET DELETED ON. The work around is to SET DELETED OFF prior to the TABLEUPDATE() and then restore the DELETED setting after the update. This prevents Rushmore from using the DELETED() tag whene issuing the update.


>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
Previous
Reply
Map
View

Click here to load this message in the networking platform