Page 1 of 1

Reuse Deleted Records

PostPosted: Thu Sep 13, 2007 2:50 pm
by Greg Gammon
Ok...now that Ive solved all my browse issues (thanks James!!!), Im ready to tackle re-using deleted records to avoid that pesky downtime for packing.

Ive read a few posts but not sure I completely understand....

Right now im just doing the standard oDbf:append()....load()....save()

Can I get some code examples on how to implement finding deleted record, blanking, using Database object?

Thanks!
Greg

PostPosted: Thu Sep 13, 2007 5:16 pm
by James Bott
Greg,

Already sent to your email.

Everyone, this is code for selected TData registered users only. The new code is beta-test code right now.

There are actually two new features, 1) automatic deleted record reuse (no more PACKing!) and 2) auto-incrementing primary-key fields. Almost no code changes will be required to implement these new features.

TData is an enhanced database class. For more information about TData go here:

http://ourworld.compuserve.com/homepage ... rogram.htm

Be sure to read the OOP articles too. They show how using database classes can really reduce your code and increase your programming power.

James

PostPosted: Thu Sep 13, 2007 8:57 pm
by R.F.
Greg and James:

Is my understanding that xHarbour CDX driver already recicles automatically the deleted records.

PostPosted: Thu Sep 13, 2007 9:19 pm
by Greg Gammon
Well that would certainly be sweet if that is the case. Are you saying the oDbf:append() automatically seeks deleted records to reuse?

Also...what IS the difference in Harbour and xHarbour (im just using Harbour).

Thanks!
Greg

PostPosted: Fri Sep 14, 2007 9:27 am
by Enrico Maria Giordano
RF wrote:Greg and James:

Is my understanding that xHarbour CDX driver already recicles automatically the deleted records.


Don't think so. It would be a serious incompatibility.

EMG