Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View Question?
Message
 
À
21/02/2001 13:50:36
Bob Lucas
The WordWare Agency
Alberta, Canada
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Divers
Thread ID:
00478086
Message ID:
00592792
Vues:
16
How do you do a SQL Passthrough and Truncate Table?

I'm looking for specific code--I can't find it on UT or MS sites.

TIA,
Joy

>Are there any constraints on the table that would prevent a parent record from being deleted if there is a child record?
>
>It is much quicker to do SQL Passthrough and TRUNCATE TABLE then to do a delete all.
>
>It is also possible that you do not have enough log space to handle the deletes. When you delete records the deletes are all logged and if you have a lot of records being deleted, it may fill the log. Check to see if you have restricted growth on the log table.
>
>And again, Truncate Table does not log deleted records so it is rather final, but very quick.
>
>
>>I have a remote view/Updatable to a SQL 7 table. I try to zap the record set,
>>but that does nothing. I try to delete all in the remote view and
>>get back a update conflict message. any Ideas? Thanks Eric.
CLARC Services, Inc.
3500 Tamiami Trail
Port Charlotte, FL 33952
www.clarc.com
(941) 743-0108
(800) 246-5488
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform