General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi !
You can use sys(15).
I used function like this to create an index with proper polish order in my DOS apps. : sys(15,m.PolChars, indexedfield ).It worked.
>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.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only