UniQuery's Fetch Rows Property

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
ninadgac
Posts: 4
Joined: Sun 13 Oct 2013 06:18

UniQuery's Fetch Rows Property

Post by ninadgac » Fri 06 Dec 2013 16:38

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?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: UniQuery's Fetch Rows Property

Post by AlexP » Mon 09 Dec 2013 07:20

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';

Post Reply