Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
Show a Progress Bar During Deletions
I have several tables that need to be cleaned up periodically, i.e. deleted and reindex (which also packs the table). This will take a while and I would like to display a progress bar to reassure the user that something is happening. I have two cases:
1. single table
2. two tables with related by ref integerity rules.
I use code like the following
DELETE ALL FOR expresion1 [AND expression2 [ AND ... ]]
with one to three expressions. Can this be done if so how. Would a SCAN loop be better (what are the performance hits). During testing I noticed deletion for tables with ref integrity rules seem to take a while.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement