I need help of how to
load a datasets partially using Delphi 6 ?
The DB server I use is SQL Server 7.
I have a table named Mstr_Member.
It has 1000000 ( A million records ).
It's crazy or even not possible to load them all at once.
I want to load them partially. For example, each 500 records.
For example, the first time load, shown 1 to 500.
Then, when I scroll down the cursor at TDBGrid, it could change
to 501-1000 or maybe 300-800.
So, It's always fast to load the table data.
Even it have a huge data, very huge data.