packing of dbf database using ADO

[rongarcia1105]

hi! is there anyone who can help me on how to pack a dbf database file using ADO? thanks in advance!!!

[randem]

Yes, I am confused too...

Pack a dbf? if you mean something like re-orging the database, I believe dbf file needed to be unloaded and re-loaded to regain the lost space.

[rongarcia1105]

i've reloaded the database but the flagged record is still there...just wanna know is there any way to do the packing of the dbf database using ado?

[AIS4U]

ron....:

I will certainly defer to all the database gurus out there, but to my knowledge the "Pack" command isn't used anymore, except maybe in Foxpro.

I haven't seen it since my days of using dBaseIII under DOS.

I think one reason it has disapeared is because, although it removed the flagged reocords, it actually increased the size of the database.

Also, with the tremendous improvements in DMS since the old dBase days, it is no longer needed. Just delete the unwanted records.

I could be wrong about this, but a Google search seems to bear it out.

[randem]

rongarcia1105,

Who flagged the records in the first place... You mentioned nothing about deleting records.

Foxpro is just an updated version of dBase...

[rongarcia1105]

AIS4U,

Yes, I know that dbf databases are only being used in foxpro. Im just using that database because of I'm just accessing it from a currently existing application. The application is made by citect and they're using dbf's as database.