TUniquery - How return only top 10 records?

hebrao · 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 · 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.