Hello Przemek,
Thank-you very much for the detailed explanation and the additional most
helpful information.
At this time I need to co-exist with pure Cl*pper files and indexes, but
once I get all systems converted to Harbour, I will look at improved
functionality. When the time comes, your suggestions for rddInfo(
RDDI_SORTRECNO, .t., "DBFNTX" ) and rddInfo( RDDI_MULTITAG, .t., "DBFNTX" )
are very interesting, or would it be better to convert all to FoxPro CDX?
Also I might suggest updating the Harbour documentation for the STR()
function which currently reads as:
STR() returns <nNumber> formatted as a character string. If the optional
length and decimal arguments are not specified, STR() returns the character
string according to the following rules:
Results of STR() with No Optional Arguments
Expression Returns Value Length
Field Variable Field length plus decimals
Expressions/constants Minimum of 10 digits plus decimals
VAL() Minimum of 3 digits
MONTH()/DAY() 3 digits
YEAR() 5 digits
RECNO() 7 digits
Thanks again and to ALL for the outstanding work,
Heinz Bergen
>BTW if you do not need to access the indexes by Clipper then you can
>reach the same effect much easier.
> rddInfo( RDDI_SORTRECNO, .t., "DBFNTX" )
>enables Harbour extension which causes that in newly created indexes
>RECNO() is calculate as hidden trailing part of the key just like in
>CDX or NSX so it gives effectively the same without adding any STR(RECNO())
>to index key and without increasing the index size. It also eliminates
>potentially big performance problem caused by linear scan in NTX indexes
>using a lot of non unique keys when they have to be positioned after
>GOTO or for update.
>You can also use:
> rddInfo( RDDI_MULTITAG, .t., "DBFNTX" )
>to enable support for multitag NTX indexes - many indexes (tags) in
>single file like in CDX or NSX formats.
--
View this message in context:
http://old.nabble.com/Clipper-NTX-Index-Corruption-tp28104017p28107812.html
Sent from the Harbour - Dev mailing list archive at Nabble.com.
_______________________________________________
Harbour mailing list (attachment size limit: 40KB)
[email protected]
http://lists.harbour-project.org/mailman/listinfo/harbour
