Hello, gentlemen.
Upon further investigation it became clear that index has nothing to do with this.
I've made the tables free and indexless.
Cs1.dbf - parent table, PK C(16) NoCPConvert - primary key
Cs2.dbf - child table, Cs1_pk C(16) NoCPConvert - foreign key
Select * from Cs1 left join Cs2 on Cs2.Cs1_Pk=Cs1.PK
This query gives correct result when CodePage=1251 (in config.fpw). If CodePage is changed then the query result is messed up. I wonder where NoCPConvert comes in...
Have a good day.
Kamil
>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
A moment of silence is our cosmic reset button.