General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
actually we can't open the table if chinese-star program haven run yet
so we can't kill the cdx and recreate it unless the chinese-star program is running first.....
after killing and recreating the cdx, the same thing happen if we forgot to run the chinese-star program again !
another thing is all the MS Office application can key in chinese charactor whith language CH come with XP but VFP cannot ! Why ????
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only