Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Want to pack a table without removing deleted records
Message
From
31/08/2004 16:40:29
 
 
To
31/08/2004 16:19:03
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00938167
Message ID:
00938198
Views:
19
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform