Page 1 of 1
Reuse Deleted Records
Posted: 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
Posted: 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
Posted: 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.
Posted: 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
Posted: 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