Devart Forums

At my UniQuery component FetchRows property is set to 25 by default. While I dont want to set any limit on FetchRows , I want extract as many as rows are there in DB table may be it 25 or 1000 , it is not possible to define FetchRows count property exactly in such cases where we are not aware about number of records.

How to overcome this problem?

Hello,

To solve the problem, you should either set the FetchAll property to True. If you set the FetchAll property to true, all the data will be fetched at once in DataSet

UniQuery.SpecificOptions.Values['FetchAll'] := 'True';