Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting all records in a view
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00102200
Message ID:
00102296
Views:
24
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
Previous
Reply
Map
View

Click here to load this message in the networking platform