Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Deleting all records in a view
Message
De
27/05/1998 14:38:48
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00102200
Message ID:
00102463
Vues:
24
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform