Data Pagging !

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply

Data Pagging !

Post by b_yaghobi » Mon 08 May 2006 07:26

How can we use SDAC in Pagging mode ?

1) FetchAll = False
2) FetchRow = 25

3) DataSet.Last

we want SDAC come only 25 last record.

( TTable in Delphi strongly support it )

Is SDAC support it ?

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Wed 10 May 2006 12:02

SDAC doesn't support such functionality.
FetchRows property just indicates number of rows that will be transferred across the network at the same time.
You can use TOP keyword, UniDirectional = True mode or server cursors.


Post by Guest » Thu 11 May 2006 10:58

Hi Corelab Team

I have not your project source, but if you can add cursor map on
your record buffer and release previews buffer an add
fill your buffer with new page of data (For example 30 rec per page)
you can add important tools your project,
i can help you rb this functionality.

Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Fri 12 May 2006 15:09

We will investigate the opportunity of adding such functionality in the next SDAC version.


Post by Guest » Sat 13 May 2006 10:29

CoreLab Team

Thank you.

Best Regards
Babak Yaghoobi

Post Reply