🚀 go-pugleaf

Hi boys,

I'm using DBF DBase IV compatible tables with .MDX type indexes in my
application

I have a problem using the DbiRegenIndexes function.

The sequence that unslash the problem is the following :

- I insert a lot of records ( The indexes are well updated )
- I delete some records from the table ( I can see the '*' mark at the start
of the record wich means that the record was correclty deleted in the DBF
file)
- I launch the DbiRegenIndexes function ( to simulate a lost of sync between
Table <-> Index )

----- Now i observe that inside the rebuilded index still contains the
deleted KEYS ( Why?) ----

Now, at this point , If i try to insert the same KEY of a deleted KEY, the
system throw an exception ( DUPLICATE UNIQUE KEY EXCEPTION OR SIMILAR )

Do i perform some wrong operations ?
What is the right operation sequence to Delete and Re-Insert records with
the same INDEXED KEY and how i can perform a safe index rebuiding ?

Please help me ....

Thanks,
Furno Gianluca

info@microshadow.com