>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é