FiveTech Software tech support forums

Hello,

If I change a record in a DBF-file and I only change the date, then the record is shown twice after it is updated.

In the DBF-file, the record only appears once, but if I change from natural order to an index, then the record appears twice.
It only happens after the record has been changed.

Anyone any idea what might cause this problem?

Thanks.

Michel,

It looks as a corrupted index.

Have you try to delete the index and reindex it again ?

Antonio,

I deleted the CDX-file several times and then I reindexed, again and again. But nothing changes.

If the problem occurs, I reindex and all the data are correct again. But is my index made corrupt?

Michel,

Could you reproduce it on a small example that we may try ?

Antonio,

It is not so easy to reproduce a small example.

But I will send you some files by email.

Thanks.

Can we see the code that creates the index?

I have had a similar observation, but I can't say it is related to a date field.

For some reason, with the past couple of releases of FWH, I am finding that some clients have indexes going bad. There have been no changes to the index format, which is:

DELETE FILE evecfx.cdx
oDB := tdata():new(, "evecfx",, .f. )
IF oDB:use()
oDB:createIndex( "evecfx", "cfvnsp",,, .t., 10 )
ENDIF
oDB:close()

Suddenly I have been getting calls from clients and they have to reindex frequently to eliminate problems just like stated above.

It is hard to get a small sample, but perhaps it would be possible to look at changes that might have been made in the indexing method for creation or updating. Maybe it is in the database object ?

Tim

If it is an index probem I would think that it would be a (x)Harbour issue rather than a Fivewin one. The (x)Harbour RDDs handle the building and use of indexes.

Maybe you could try compiling with an older version of FW/(x)Harbour.

Michel sent me an example to review the problem but with FiveDBU it shows fine:

Ok, Michel just explained me how to reproduce it.

To me it seems as a RDD bug. We should try to reproduce it on a small example without FWH and report it to the Harbour developers list.

Michel, could you prepare such small example for me ? Please try to create the DBFs from the PRG itself, so we don't need to attach any files when reporting it.

many thanks

Antonio and James,

The problem started surfacing on my distribution copy of my application. That is the one that is built with xHarbour ( .com ) on a version that has been used for several years.

The problem has only been brought to my attention in recent months, so the only change made would be FWH. The current distribution uses FWH 14.09 with xHarbour ( .com ).

If it was an RDD problem, it would have shown up about two years ago.

I do use tData ( which draws from tDatabase ), and you have made changes in FWH to tDatabase ... so I would suspect perhaps therein lies the problem.

Tim

Tim,

As far as I know Michel is not using Class TDataBase.

I have reported this problem to Viktor Szakáts and I have sent him Michel files, so he may be able to check it for himself and asked his help to report the bug in case he also confirms that looks like a bug.

I have been able to reproduce Michel's bug using FiveDBU only, so to me it seems as a RDD bug that somehow is manifesting now.

Antonio,

Any news yet concerning my problem?

I did some more test today.

As you know until a few months ago, I was using xHarbour builder.
So today I tried to rebuild my application using xHarbour builder.

Also in this version, the same problem is happening.

I just wanted to let you know.

Look, please:

http://www.ea6dd.com/ftp/bielsys/dbfcdx ... ndices.pdf

Regards.

Michel,

No more news from Viktor, I am going to email him again now