>I have a problem as fallows: I am working on an FOX 2.6 international application that should work with English and Hungaian letters. I would like to make an order on a field that has english and hungarian data. Hungarian letters are same in 28 letters as english but has some extra letters those are between English letters in alphabet list but their codes in hungarian codepage are not in their correct places. I should insert them between english letters in my index. Think of it as I should make an order based on a new alphabet list in english (for example) that one new symbol should be inserted between "A" and "B". Notice that the code of "A" is 65 and "B" is 66 and I want my order sort the field in ascending mode in a case that "A" is before my symbol (That its code is 196 for example) and "B" is after it.
>(Fox 2.6 doesn't have hungarian collating sequence.)
>
>Thanks for any idea.
I believe that if VFP doesn't support this specific collation sequence, and the "general" is not satisfactory for you, you have to create your own UDF() to do the sorting. Or perhaps, just create your table of characters (in memory variables), and use ChrTran() to translate the characters.
HTH, Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)