>Hi.
>I have index on char binary fields in two tables which i link with relation. The relation works only with the code page under which the index was created. So NOCPCONVERT is neglected when an index is created. This seems illogical... to me at least.
>(VFP 8.0)
>All the best.
hi Kamil,
I think that it is the collating sequence of the index that is important. For binary fields the one to use is 'Machine'. Any other will cause trouble (Kamil = KAMIL = kamil)
So, you may have to drop the indexes and recreate them with Machine collating sequence
Gregory