>Hi,
>
>One of application had a auto index feature.
>It used to work fine.
>However, recently, when working on displaying
>chinese character, I change my win2k system
>to chinese locale.
>
>Now, when my VFP5 open any dbf file, my system
>locale will auto change to chinese, any input
>into the dbf file will be display as chinese.
>
>That is when my application when doing auto
>indexing will give error of
>
>Error number: 1915
>Error message: Collating sequence 'PINYIN' is not found.
>
>I had tried to set my application COLLATE TO "MACHINE"
>and use cpzero on my dbf file but all in vain.
>I had even set my VFP5 collage sequence to MACHINE
>
>Pls advise on how to solve the above issue
>and why.
>
>Plus how to change my VFP5 environment to
>input English insteads of auto input
>chinese.
>
>Any help or advise is very much appreciated.
>Thank you
The indexes will only be built using the current collating sequence (in versions 2.6 to 7 - in 8 you have the option to set it for the current tag). So, you'll have to delete the offending tags, set the collation sequence to what you want, create indexes.
Setting the collate sequence doesn't affect tags which already exist, only newly created. But it does affect the string comparison.
The error message - look for the file foxpro.int (it contained collating sequences in 2.6 to 6, don't know where are they in 7 and 8), if it's not there you may see that error.
As for the input locale, can't help you, it's in the API somewhere. You may try
Keyboard "{ctrl+3}" plain clear
or whatever is the sequence for switching input locales on your box, but I'm getting an error when I try that (VFP 7), and these sequences are user's settings, so you don't really know what they are.