Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Delphi Event generation and handling , using TclientDataSet with pagination --> urgent

Posted on 2006-04-19
1
Medium Priority
?
510 Views
Last Modified: 2010-04-05
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.
0
Comment
Question by:javaoptimizer
1 Comment
 
LVL 6

Accepted Solution

by:
Imthiyaz_ph earned 2000 total points
ID: 16485645
Check the stateless fetching example from this site:
http://www.distribucon.com/midas.html

It shows how the pass a key value from the client to the server and fetch the next set of records (using PacketRecord property).

For your case, you may need to modify the BeforeGetRecords of DataSetProvider to return a resultset of a query something like this:

Select Top 1000 * From TableName
Where ID > SomeValue

This will work only if the ID s are incremental.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses

581 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question