>>>>Using vfp5...
>>>>
>>>>I noticed that my dct file for my dbc had grown to 14MB. I opened the
>>>>dbc (use myprog.dbc in 0 exclusive) and then packed it. That decreased
>>>>the dct file dramatically. I thought "build project" did this but
>>>>apparently not. I do this all the time for dbf files but never for
>>>>a dbc. So is what I did ok?
>>>
>>>
>>>Joe;
>>>
>>>Sure! Just a bit of housekeeping.
>>>
>>>Tom
>>
>>
>>So "build project" isn't supposed to take out these deleted records?
>
>Nope, it will furthermore include any deleted records in your classlibs into your .exe, with all the memo bloat. Though, the DBC is not included in your project, it's supposed to be shipped separately. Anyway, any time you do any structure changes (add-rename-delete-resize-redefine fields, add-drop-modify index, edit a view, edit stored procedures, you name it), the records where the old information was stored in the dbc are deleted, and new ones added. You can open the dbc as a table and check the numbers. If you Set Deleted Off and notice any deleted records, it's about time you packed it. Or you may just need to pack memo.
>
>If you open up the dbc exclusive, in the menu you will notice a "Clean up database" line (which may be disabled if you got no deleted records or no memo bloat - I really wouldn't know how does it decide when to enable it). What it does is pack, renumber the ObjectId and ParentId fields, and probably recompiles the stored procedures. I think it'd rather do the latter first, because the compiled code goes into memos, which then creates more memo bloat - so it would better be cleaned up in the end.

Thank you!