Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Deleting all records in a view
Message
From
27/05/1998 14:38:48
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00102200
Message ID:
00102463
Views:
23
Hey guys ----

Switch over to SQLEXEC() and execute an SQL DELETE?

>>Does anyone know how to delete all the records from a remote view. I have a table with 4500 records. I used DELETE ALL from a remote view of that table (I must use a remote view) but it takes like five minutes to perform that operation. I need a faster way to do this but I can't use the table directly.
>>Thank you.
>
>How do you have the table buffered? Are you using ROW or TABLE buffering? If you are using ROW buffering, try table buffering the sucker and then doing the tableupdate.
>
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform