sorting Valuelist in 3.5b3

Classic Servoy
1

Hi Guys,
I am creating a valuelist in 3.5b3 using a dabase table to provide the data. I have a combobox that is checked to sort the data. No matter whether I put ascending or descending for the sort, the data is always showing as descending.
Any ideas on what I’m doing wrong?

Servoy 3.5.b3
Mysql 5.0.24
Java 1.5.0_06

Thanks
Graham

2

Graham,

The sorting is defined on the value list, not on the combo box.

Rob

3

Hi Rob,
Thanks for replying. I sorted on the valuelist, by clicking on the sort button at the bottom of the valuelist. I have the show in field list button clicked for dept, and return in dataprovider clicked for the same field. No matter whether I change the valuelist to sort asc or desc on that field, it sorts descending. These are valuelists that have worked since servoy 2

Is it just my setup with mysql?

Thanks
Graham

4

Graham,

Try the latest 3.5 (beta4) Servoy version.
If it still does not work, please create a case in our support system, make sure to include a small sample solution.

Rob

5

Try the latest 3.5 (beta4) Servoy version.

I have the same even in 3.5b4

6

Hi Rob,
Ok - maybe it’s the gremlins - I created a new database, 72 records in all, created a small table with lastname, dept and dept2 on a new form - created a valuelist on all three, sorted asc and desc and the valuelist sorts as it is supposed to. Everything works on the sample solution.

I go back to my development solution (1771 records) - remove and add the fields to the form, create new valuelists sort as I did on the sample solution and I get a descending sort each time. Even if I change it to ascending.

I go back to my sample solution, drop the table and create a table with 3 fields and 1771 records, and lo and behold, the sort is descending, even with the valuelist set to ascending.

I’ll send in a support request along with the sample solution.

This happens in 3.5b4.

Graham

7

Aren’t value lists limited to 500 entries? Maybe that’s where the sorting then goes wrong…

8

Hi Patrick,
Thanks for the reply. It seems that you are correct. If that limitation is there, then I will have to create a lookup table on all the valuelists I have, since I can no longer use the fields in a single database, since I easily hit that limit.

The joys of taking a Filemaker flatfile and trying to work with the result in a relational database.

Graham

9

Thanks Patrick and Rob,

The problem was solved by creating lookup tables with less than the 500 record limit.

A good thing to know.

Graham