Valuelist not sorting

Classic Servoy
1

Hi Guys,
I’m not sure if this is a bug, my inexperience, or just a limit I’ve bumped into.

If I create a valuelist based on a table in my database and sort the valuelist ascending or descending, it works if I have a small number of records in the database (72 in my test case). If I use it with my development database which has 1771 records in the database then the valuelist only displays a descending sort (even if the sort is ascending). Changing the sort on the valuelist makes no difference.

Any answers would be appreciated - even if I need to redesign the database I inherited.

I also have a reply from Rob Ganselves in the programming forum, to send in a support request, but I’m not sure with this new information whether it is a suppor issue or not.

Thanks
Graham

2

Sorry - I am using Servoy 3.5b4, MySQL 5.0, Java 1.5_0_6 on windows XP. The database is using INNODB.

Graham

3

Problem solved.

The 500 record limit is the culprit. I created lookup tables for my valuelists that are based on tables, and the problem went away.

Thanks to Rob and Patrick for their input

Graham