>>Now, this would apply to whom that uses collate sequences.
>>Config.fpw :
>>codepage=1254 && Turkish windows
>>collate=TURKISH
>>
>>-create a table
>>-index on a field
>>-enter some values to that indexed field ie: 5 records all "John Smith"

>>select * from mytable ;
>>  where myfield = "John Smith" &&Displays only one record
>>? _tally   && Prints 0
>>set collate to "MACHINE"
>>select * from mytable ;
>>  where myfield = "John Smith" &&Displays all
>>? _tally   && Prints 5
>>set collate to "TURKISH"
>>* Same as above _tally = 0

So what could I be missing ????
>>Cetin
>
>Cetin,
>
>I tried this in 5.0a SP3
>
>CLOSE DATA ALL
>SET SAFETY OFF
>
>CREATE TABLE TEST (cName C(20))
>USE TEST.DBF EXCL
>
>FOR i = 1 TO 10
> INSERT INTO TEST VALUE ("John Smith")
>ENDFOR
>
>SET COLLATE TO "GENERAL"
>INDEX ON cName TAG Name
>
>SELECT * FROM TEST WHERE cName = "John Smith"
>? _TALLY && returns 10
>
>SELECT TEST
>SET COLLATE TO "MACHINE"
>DELETE TAG ALL
>INDEX ON cName TAG Name
>
>SELECT * FROM TEST WHERE cName = "John Smith"
>? _TALLY && returns 10
>
>So everything seems fine on my side. But I can't set COLLATE TO "TURKISH". This generates an error. My FOXPRO.INT file must be too old (21/08/96).
>
>José
Thanks Jose,
I don't have SP3 and it seems to be the problem.
Cetin