Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Collating sequence
Message
De
12/04/2002 07:42:00
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivie
 
 
À
12/04/2002 07:33:11
Balazs Simon
Unit Informatics Ltd.
Budapest, Hongrie
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00644153
Message ID:
00644157
Vues:
11
>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)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform