Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Collating Sequence not Found error
Message
De
28/06/2007 20:59:35
Hee Lim Wang
Fantasy Software Enterprise
Malaisie
 
 
À
27/06/2007 14:04:53
Dragan Nedeljkovich (En ligne)
Now officially retired
Zrenjanin, Serbia
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
01236057
Message ID:
01236654
Vues:
10
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform