How to PACK DATABASES for deleting 'deleted' records?

Tell me please, how I can pack databases for deleting all
deleted records? What I need to do?
Thanx
hindAsked:
Who is Participating?
 
icampbe1Commented:
Call dbiPackTable with the engine's handle for that cursor.  dBase files use this 'deleted' feature.

eg.  Check( dbiPAckTable( Table1.DBHandle, Table1.Handle, '', szdbase, True ));

Assuming your table is Table1, the above will work.
0
 
icampbe1Commented:
Oh yeah....  you have to include 'BDE' in your uses clause.  Also, I seem to remember that the dataset must be opened exclusively for the call to work.

Cheers,
Ian C.
0
 
JimBob091197Commented:
According to the BDE help, DbiPackTable doesn't work for Paradox tables.  You have to use DbiDoRestructure using bPack for Paradox tables, although you use DbiPackTable for just about every other kind of table (including dBase).  Strange...

JB
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.