TUniquery - How return only top 10 records?

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
hebrao
Posts: 1
Joined: Thu 02 Dec 2010 20:15

TUniquery - How return only top 10 records?

Post by hebrao » Thu 02 Dec 2010 20:23

Hello!

My query returns 200 records... and i want put a button on my application form to filter only top 10.
Note: i can't change my SQL... the Uniquery must do it by itself.


(PS: TADOQuery has a property MaxRecord... is there anything like that on Tuniquery?)

Thanks.

Heber

Dimon
Devart Team
Posts: 2888
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Fri 03 Dec 2010 13:04

UniDAC doesn't support such functionality. You can change the SQL query. Or, as a workaround, you can set the FetchAll option to False and the FetchRows property to 10. You can find more detailed information about these properties in the UniDAC help.

Post Reply