IndexFieldNames problem

[geanni]

Hi,

I have a problem related to IndexFieldNames on a query.
I have 3 entries int a table "users" and for "name" column I have: aa, ff, gg.

The code for sorting column is:

MyQuery1_bookings->IndexFieldNames = "name ASC CIS";
MyQuery1_bookings->IndexFieldNames = "name DESC CIS";

The problem is that the result is: ff, gg, aa for ASC and aa, gg, ff for DESC.
The problems seems to be "aa" because if a change it to "ab", "abaa" it works fine.

Is it a bug, or I done something wrong?
Thanks

[Dimon]

I can not reproduce the problem. Please send me a complete small sample to dmitryg*devart*com to demonstrate it, including a script to create and fill table.