Record Navigation with large datasets. Was: href prob 2.1b4

Classic Servoy
1

Hi,

I’m trying to write some generic record navigation code to find a way to avoid using list views with lots of records.

I use SQL queries to get only a batch of records at the time. I have initially set the batch size to 10 for debugging purposes.

I have attached a simple solution which will work with Sybase. The next and previous buttons in the navigator work fine. My current problem is that the HTML next and previous buttons on the form don’t work.

Also, my solution relies on getting the total number of records and storing this in a global, which mean I have to query the database twice in some cases :-(.

I’m going to add logic to search so you only work on a subset of the records.

Any suggestions for improvements are welcome…

2

My current problem is that the HTML next and previous buttons on the form don’t work.

in 21b4 href links don’t trigger anymore. (is fixed for in coming bea relaese 21b5)
I tested your solution with 21b5. Works fine :)

3

Aahh. That explains why my <a hrefs weren’t working…