Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DCT file
Message
 
To
26/07/2000 06:48:24
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00396959
Message ID:
00397000
Views:
6
>Can someone tell what the DCT file contains and why it perhaps growed on my test system from around 300K to 14MB?
>
>Thanks
>Kev

Kev,

A VFP dtabase container is comprised of three files a DBC, DCT, and DCX. The DBC is a VFP table with the rcords of the databse, the DCT is a memo file that holds many of the settings of the database, and the DCX is an index file (like a CDX). Thhe DCT grows becuase every time you make changes to your database settings the memos are updated and VFP updates memos by marking the current entry as obsolete and creating a new entry for the data. You can clean this up by;

Open the database exclusive
Choose Clean up database from the Database menu

OR;


USE MyDatabase.DBC EXCLUSIVE
PACK
USE


Either way the DCT file will get packed and the slack space will be recovered.
Previous
Reply
Map
View

Click here to load this message in the networking platform