>>>>>>Hello Doug. I have no SET COLLATE statements anywhere in my application. When my application tries to open certain files this error pops up. All indexes in my files are set to machine collate. I do not make any explicit SET COLLATE statements.
>>>>>
>>>>>Is it possible that database collation is set to this file? E.g. what CPDBF() returns?
>>>>
>>>>No this is not possible. But I do use CREATE CURSOR and CREATE TABLE commands. Could this default to PINYIN collate sequence and then the file is missing?
>>>
>>>I actually meant tables in my reply, not DBC. Anyway, I believe it's possible for tables to have wrong collation if you didn't explicitly specify it.
>>
>>Yes, I am also talking about tables. They are all set to machine collate sequence. I really have no clue what collate sequence means or how to use. Have never needed to use it until this user in Singapore came up with this issue....
>
>Can you also check indexes for the tables?

They are all set to machine.