Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Want to pack a table without removing deleted records
Message
De
31/08/2004 16:40:29
 
 
À
31/08/2004 16:19:03
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00938167
Message ID:
00938198
Vues:
20
>Sorry,
>I have another file with extension .tbk which is 500 MB
>
>what is this file is it a back up file.
>
>Does this .tbk file also gets included in the 2 gb file size for a table.

.tbk file is a backup of the memo file...don't think it is part of the 2 gb limitation (it certainly is limited to 2gb by itself).

>
>My .dbf is 200 MB and cdx is also 200 mb and fpt is only 10 MB.
>So if at all the menu's and general fields only go to fpt which is small in size.
>

That doesn't look like you have 1.5 gb. You meant memo, not menu, right?

The limitation is 2 gb for the .dbf file, and 2 gb for the .fpt file. They are separate limitations. If you need to keep the deleted records, from what you have just said packing won't gain you much. And it may not be necessary. However, I'd be more inclinded to put the deleted records in an archive table, with a real field containing a flag indicating they were deleted out of the main table.
Steve Gibson
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform