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.
Limit the size of the data returned by the query
Re: Limit the size of the data returned by the query
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
FetchAll: https://www.devart.com/unidac/docs/deva ... tchall.htm
FetchRows: https://www.devart.com/unidac/docs/deva ... chrows.htm
Re: Limit the size of the data returned by the query
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
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
Re: Limit the size of the data returned by the query
Please specify the DBMS you are using.
Re: Limit the size of the data returned by the query
MS SQL Server 2005
Re: Limit the size of the data returned by the query
TSQLServerUniProvider does not have a separate feature to limit data size fetching. Try searching for a ready-made solution at specialized forums.