Hi, I'm a newbie with dbforms + have question:
How could I display the current record position in my record view? I like to show something like "this is record 11 of 51".
Thanks in advance!
Theo
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I must correct me - there is an example how to retrieve the count of records inside dbforms. Look at the bookstore example and the testBookList.jsp. The book table uses an special version of the dataaccess classes
DataSourceJDBCWithRowCount wich do a second query to count the rows. I should be possible to extend this example to add an calculated field to the table which will hold the row number
Hope that helps,
Henner
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi, I'm a newbie with dbforms + have question:
How could I display the current record position in my record view? I like to show something like "this is record 11 of 51".
Thanks in advance!
Theo
No change. dbforms only nows the count of records after you have reached the last one.
cheers,
Henner
Ok, no count of all records. But is it possible to get the current position only?
regards Theo
No no current row. Pointer in ResultSetVector is pointer into the current resultset - this will change if you go to the next page.
Could you add an maybe calculated field into your tabledefinition? Then you know the rownum?
Henner
cheers,
Henner
I must correct me - there is an example how to retrieve the count of records inside dbforms. Look at the bookstore example and the testBookList.jsp. The book table uses an special version of the dataaccess classes
DataSourceJDBCWithRowCount wich do a second query to count the rows. I should be possible to extend this example to add an calculated field to the table which will hold the row number
Hope that helps,
Henner
Ok, I will try to do it.
Thanks + regards
Theodor
Would be great if you send me your results - based on the bookstore example. So we can insert a howto page to the project!
Henner
Found another hint:
See bookstore
tests/testSearchAndCalcFields.jsp and BookstoreCalcFieldAndSearchInterceptor.java for an example how to calc rownum!