FiveTech Software tech support forums

Olá

És correcto utilizar em todos los tags la clausula For ! Deleted() e em los objectos browses utilizar:

oBrw1:bLogicLen = { || TABOCOR->(OrdKeyCount()) }

Para que la barra verticale funcione corretamente?

Gracias.

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

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

Greg and James:

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

... 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 ...

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() ...

... get packed which could take a half hour. You have to pack databases using a separate routine that the user can call occassionally. You can leave deleted records in the database for quite some time unless you are deleting lots of them and if you doing that you need to rethink the design. Still ...

No harm fom putting pack after using the file like below or you think there is a better place to for the pack for the deleted commands :

Code: Select all  Expand view

use mete exclusive
    index on me_mc_serl to mete
    index on me_date to mete2
    pack
    use
   

... some time, headaches and aspirines the problem appeared with pack. The best solution was to change APCK command for a Rename/Create/Append From !Deleted(). Regards, Carlos.

... to me three times in the past month. The main database will typically only have 250-300 live records, with maybe another 200 or so that have been deleted prior to a pack and reindex. Then BOOM...some operation has cause the database to expand to anywhere from 4000 to 16,000 records, the entire ...

... suggestion as before is to reuse records. Or, you can pack during reindexing which also requires exclusive use. When you delete records with SET DELETED ON, they will be invisible so there is no need to pack. Also when you when you index you should always use the FOR NOT DELETED() clause so the ...

Where in code can I pack the deleted records and in same time keep the existing browse as BrowseDelete(oBrw,oMeter) ? I f packed the shape of the browse is going to be redisplayed aganist BrowseDelete(oBrw,oMeter).
Thanks

Ehab,

>How to pack . when ever I involve pack command I faced with DBF execlusive required !!

A better solution is to reuse deleted records. Change the delete method to blank out the record and the append method to look for blank records before adding a new one.

James

Can I have the old browse with the first record browsed before the deletion ? I mean updating the browse having the first ecord before the deletion except the record deleted .

What I needed is to make the record deleted disappeared immediately from the browse ( INSTANTLY). That what I asked for .
Thanks