Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting all records in a view
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00102200
Message ID:
00102296
Vues:
25
Hi Eduardo

Think about the fact, that every single delete of a record will be sent as an single command, normaly wrapped in a transaction, to the sql-server.

It is better to send a delete command to the sql-server, because the command runs much faster and only one transaction is wrapped around.

After this you can make a requery()

Peter from germany
Greetings
Peter Herzog, germany

|\_/| ------------------------------------------------
(.. ) run the fox on the web
- / http://www.active-foxpro-pages.de
PROLIB Software GmbH http://www.prolib.de
MVP Award for Visual FoxPro
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform