Solved

How to PACK DATABASES for deleting 'deleted' records?

Posted on 1998-04-06
3
207 Views
Last Modified: 2010-04-06
Tell me please, how I can pack databases for deleting all
deleted records? What I need to do?
Thanx
0
Comment
Question by:hind
  • 2
3 Comments
 
LVL 2

Accepted Solution

by:
icampbe1 earned 100 total points
ID: 1361304
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
 
LVL 2

Expert Comment

by:icampbe1
ID: 1361305
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
 
LVL 5

Expert Comment

by:JimBob091197
ID: 1361306
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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Connection between libmysql.dll and MySQL Versions 7 113
Delphi IDE crash without error message ... 7 99
Multiple image collision 13 80
firemonkey Android Listview Sort items 7 54
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question