Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
TableUpdate() is taking 5 minutes to save data (VFP 5).
Message
 
 
À
15/05/2000 15:15:04
Diptesh Patel
Unitelsoftware Ltd.
Mumbai, Inde
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire de rapports & Rapports
Divers
Thread ID:
00369744
Message ID:
00369914
Vues:
26
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform