Hello everybody,
please imagine the following scenario:
1. I got a databound ListGrid which displays the data from a VIEW of my MySQL-Database
FYI: The VIEW joins 2 tables of the database (orders and orderitems), groups the records by a orderId and calculates same values (like SUM and COUNT) so there is no way to use the addData(Record record) function of the listgrid
2. there are so many records in the View that the listgrid uses paging
What I can alreade do is to add a new Order to the database (not via the listgrid) and then update/refresh the ListGrid so the new Order wich now exsits in the VIEW can be seen and selected in the ListGrid (after the user finds it by scrolling)
What I would like to do is to let the program select the new Record after is was added to the database. So I would have to find the new Record (i.e. by orderId) in the ListGrid. And hier comes my question:
How can I find and select a record by value (orderId) in a databound ListGrid which uses paging.
Thanks in advance!
please imagine the following scenario:
1. I got a databound ListGrid which displays the data from a VIEW of my MySQL-Database
FYI: The VIEW joins 2 tables of the database (orders and orderitems), groups the records by a orderId and calculates same values (like SUM and COUNT) so there is no way to use the addData(Record record) function of the listgrid
2. there are so many records in the View that the listgrid uses paging
What I can alreade do is to add a new Order to the database (not via the listgrid) and then update/refresh the ListGrid so the new Order wich now exsits in the VIEW can be seen and selected in the ListGrid (after the user finds it by scrolling)
What I would like to do is to let the program select the new Record after is was added to the database. So I would have to find the new Record (i.e. by orderId) in the ListGrid. And hier comes my question:
How can I find and select a record by value (orderId) in a databound ListGrid which uses paging.
Thanks in advance!
Comment