Legacy Embarcadero Discussion Forums: Navigation large database table ...

Welcome, Guest: Login; Guest Settings

Thread: Navigation large database table

Reply to this Thread

Search Forum

Back to Thread List

	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

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

Posted: Oct 5, 2015 1:28 AM

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.

Back to Thread List

Legend
	Helpful Answer (5 pts)
	Correct Answer (10 pts)

Developer Tools

Database Tools