Reuse Deleted Records

Reuse Deleted Records

Postby Greg Gammon » Thu Sep 13, 2007 2:50 pm

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
User avatar
Greg Gammon
 
Posts: 105
Joined: Fri Jun 09, 2006 3:27 pm
Location: Bryan, Texas

Postby James Bott » Thu Sep 13, 2007 5:16 pm

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
User avatar
James Bott
 
Posts: 4840
Joined: Fri Nov 18, 2005 4:52 pm
Location: San Diego, California, USA

Postby R.F. » Thu Sep 13, 2007 8:57 pm

Greg and James:

Is my understanding that xHarbour CDX driver already recicles automatically the deleted records.
Saludos
R.F.
R.F.
 
Posts: 840
Joined: Thu Oct 13, 2005 7:05 pm

Postby Greg Gammon » Thu Sep 13, 2007 9:19 pm

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
User avatar
Greg Gammon
 
Posts: 105
Joined: Fri Jun 09, 2006 3:27 pm
Location: Bryan, Texas

Postby Enrico Maria Giordano » Fri Sep 14, 2007 9:27 am

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
User avatar
Enrico Maria Giordano
 
Posts: 8408
Joined: Thu Oct 06, 2005 8:17 pm
Location: Roma - Italia


Return to FiveWin for Harbour/xHarbour

Who is online

Users browsing this forum: Google [Bot] and 121 guests