Calling Table.Delete will also pack Paradox tables. As fgar as I know
Access requires manual packing. SQL server 6.5 is horrible at this sort of
stuff (not only have you got to pack, you have to expand the size as well!).
Version 7 is much better. Don't know about the rest.
Regards,
Dennis.
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Derricutt, Mark
> Sent: Monday, 1 November 1999 11:08
> To: Multiple recipients of list database
> Subject: RE: [DUG-DB]: Optimizing paradox tables...
>
>
> > PS. Warning I think this packing removes any Security
> > features and possibly secondary indexes.
> > PPS. Includes DBIProcs and DBITypes (These may be superceded
> > in newer versions of Delphi)
>
> Thanks for all the posts, I found a routine in the delphi
> help to do this as
> well, but I think I like Aarons better :)
>
> The problem I was having was my application was hanging when
> doing a batch
> import of data to the table, packing it fixed the problem.
> Which leads me
> to wondering how client/server databases, or even access
> handles this sort
> of thing.
>
> Do they automatically pack themselves?
> --------------------------------------------------------------
> -------------
> New Zealand Delphi Users group - Database List -
> [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
