Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Collate Sequence
Message
 
 
À
03/08/2011 10:44:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Divers
Thread ID:
01520025
Message ID:
01520060
Vues:
39
>>>>>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?
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform