Devart Forums

Hi,
Excuse me, there is method or attribute for the unidac component, which can limit the size of UniQuery receiving data, such as 20MB.
Sometimes executed SQL statement, the returned data is too large.

You can fetch a dataset by pieces. For this, set TUniQuery.FetchAll to False. You can set a limit of fetched data in the TUniQuery.FetchRows property.

FetchAll: https://www.devart.com/unidac/docs/deva ... tchall.htm
FetchRows: https://www.devart.com/unidac/docs/deva ... chrows.htm

This is also a method, but sometimes it is not convenient.
For example, when a user queries data for several months, I want to limit the size of the data.
When the size exceeds the set value, an exception is reported.

Use this method before there is no better way.

Thank you

Please specify the DBMS you are using.

MS SQL Server 2005

TSQLServerUniProvider does not have a separate feature to limit data size fetching. Try searching for a ready-made solution at specialized forums.

Thank you .