![]() |
HJB 3/13/2017 |
Ascending 0123456789abcdefghijklmnopqrstuwvxyz |
R
|
reimic author 3/13/2017 |
Ascending 0123456789abcdefghijklmnopqrstuwvxyz Descending zyxvwutsrqponmlkjihgfedcba9876543210 (to read from right to left) If you sort a VARCHAR field content, using DESCENDING, it starts with 0, then 1 and so on. Say, v9.7 is sorting correctly. "Active" by check usage usually means to own either 0 for "inactive" and 1 for "active" in the field. It seems to me, assuming the field "active" to be under VARCHAR format to change same to NUMBER field format could be a workaround here as to ensure a proper sorting result.
|
![]() |
HJB 3/13/2017 |
it's working with phpr 9.6 |
R
|
reimic author 3/13/2017 |
it's working with phpr 9.6
|
![]() |
HJB 3/14/2017 |
Fixed by yesterday's build 28369 (so..., don't forget to close this thread). |