Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Fastest way to update a field?
Message
De
09/07/2002 23:43:00
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Fastest way to update a field?
Divers
Thread ID:
00676899
Message ID:
00676899
Vues:
58
I am a VFP7 user. I have a database with approx 50,000 records.
The "posted" field has the month/year that each transaction was posted (to the acctg ledger).

At the end of this month, I will issue the command:

REPLACE ALL posted WITH 'JUL02' FOR EMPTY(posted)

Wow! is it slow. Can anyone help me optimize the operation?

Thanks, Randy
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform