Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remove deleted records from a table
Message
 
À
11/02/1999 16:48:25
Sammy Derban
Ghana Telecom
Accra, Ghana
Information générale
Forum:
Visual Basic
Catégorie:
Bases de données DAO/RDO/ODBC/ADO
Divers
Thread ID:
00186785
Message ID:
00186871
Vues:
11
>Hi all'
>
>How can I actually remove deleted records from a table.
>(like pack in VFP)
>
>Thanks in advance.

Which DB are you using?

If you use engines like SQL Server, Oracle, Sybase, ... , you can't pack your DB. It is done automatically. You can do maintenance job on your server but there is no real pack.

If you use Access, you can use DBEngine.CompactDatabase method (in DAO). Access requires you to pack at some times.

If you use others (like Dbase files), you will have to write a small application (in Clipper or other) that send a Pack statement on your files.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform