>A client is getting the "Collating Sequence..." on Pinyin error after having someone in China do some data entry.
>
>I think we had this error a couple yrs ago and resolved it quickly. But can't remember what we did.
>
>Anyone have a suggestion for quickly removing the error?
Kill the cdx and recreate it. It may have been created in an earlier version of Fox (from 2.6 up to VFP 7, I think), where you could index any table on any collating sequence, regardless of the table's codepage. Since VFP8 there's a limitation, the codepage limits the choice of allowed collate sequences - you can't index a cyrillic table on Korean sequence etc.
It's also possible that the app where the data entry was done didn't enforce a codepage, so it assumed codepage=auto, accepted the Chinese codepage and created this table - the solution in that case is just to install support for Pinyin on your client's mahine, so the appropriate .nls table would be available. VFP should then be able to open the table.
A workaround may be to open the table in an earlier version of Fox, and then there append from it into a new table.