Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: Navigation large database table



Permlink Replies: 1 - Last Post: Oct 5, 2015 1:28 AM Last Post By: Robert Triest
Hubert Anemaat

Posts: 9
Registered: 9/26/02
Navigation large database table
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 5, 2015 12:56 AM
Hello,

Where can I find an example of a Delphi database application that uses navigation on a large table with e.g. 1 million records ?

TDataSet.Prior and TDataSet.Next cannot be used when I select only one record in a query.
How can I select the previous and next record ?
Is there a framework available in Delphi that can be used for navigation ?

Thanks,
Hubert
Robert Triest

Posts: 687
Registered: 3/24/05
Re: Navigation large database table
Click to report abuse...   Click to reply to this thread Reply
  Posted: Oct 5, 2015 1:28 AM   in response to: Hubert Anemaat in response to: Hubert Anemaat
Im curious about what do you want to do.. Why you want to navigate through millon records?
Is the navigate for a user or for a machine process?

The dataset only knows about the resultset of your query. If you get too many
records (a user can not browse though that many records..) then you should scope
your query in the way your query returns less records.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02