How to go about Delphi Event generation and handling and using TclientDataSet.
1) input to the TclientDataSet will be an XML with the database values
the problem is ,
1) i am new to delphi
2) from the database the no of records retreived will be around 30000 , but in need to show only first 1000 records at the start, after the user scrolls up to the last record , i need to generate an event which will hit the database to get the next set of 1000 records and so on.(pagination should occur).
How to tackle this situation. i am using an EJb application deployed as an web service, which will retreive the values from the database.
I need a suitable design and a solution in terms of idea and little bit of code snippets will be nice of you.