Browsing database with VFP CDX index - cannot move at rows

[Auge_Ohr]

hi,

For certain collating sequences, or when using double-byte character sets (DBCS) characters, each character in the eExpression parameter in the INDEX command uses two characters in the index key. In these cases, the length of eExpression is limited to 120 characters.

look at PDR 2940,4846,5694 that 120 Sign is the Limit of IndexKey() when using Collation

Now I see, it is not problem in CDX from VFP application, but I mean only problem with missing national localisation (SET COLLATE TO SLOVAK is not implemented in Xbase++, so Slovakia is small country but NOW ! chaired by the European Commission

we can not help you with missing Collation in Xbase++ DBE, this you have to ask Alaska.

p.s. you can try use ADS as local Server

[Victorio]

Jimmy:

we can not help you with missing Collation in Xbase++ DBE, this you have to ask Alaska.

writed to Alaska, but any answer...

ADS I do not know how use it, but this need Proffesional version and I have Foundation...

Thanks

[skiman]

Hi,

I would never use a left or substr in an index key. You are not sure that the result will be 30 characters.

Use padr(...,30) instead, this will always returns a str of 30 characters.

[Victorio]

Hi, skiman

I cannot change exist CDX , I have to be used as it is (created with other Visual Foxpro application).

But after reindex in my program indexing works.

Also I tryed change LEFT() function with padr(substr(field,n),1,n) , still wrong.

I found some problem, if compare content of CDX, in my (Xbase) CDX is for some field 4 characters, but in same index from VFP is 8 characters (bytes).
Index from VFP is OK, because in VFP application was used SET COLLATION TO SLOVAK.

I do not know, how set correct reading this in Xbase++. (SLOVAK collation in Alaska is not implemeted, and other GERMAN,AMERICAN... do not work.)

Look for this : selected with red color for example, also other bytes is different ,

CDX Xbase
SWEFIN clv ‰ ˙˙˙˙ ˙˙ ` a9b:b a a b‚b a b a*b+b,b a
b%b a aÇbČb
a b a b a a\b]bÚbŰb a a a aÜb a a

CDX Visual Foxpro
SLOVAK clv ˙˙˙˙˙˙˙˙Ŕ` S Ŕv` Ą Ŕ‚p · Ŕ‡x ” Ŕ‰P Ŕ‘d Ś Ŕ“h ü Ŕ•< *

[Auge_Ohr]

Use padr(...,30) instead, this will always returns a str of 30 characters.

NO

when using Collation it use 2 Byte. look at PDR 2940,4846,5694.