TAstaClientDataSet.RowsToReturn

Declaration
property RowsToReturn: Integer;

Description
The RowsToReturn property specifies how many rows to return in the result set. The default value is -1 which will return all rows. A value of 0 will return an empty DataSet. Other values will limit the result set to the RowsToReturn value. You may also set the number of rows that you want to populate at design time using the SQL WorkBench Design time Populate tab.

Note: this does not affect the server's query, only the amount packed up and dispatched by the ASTA server.

When an ASTA server runs in a threaded state using the Persistent Sessions Threaded Model, the RowsToReturn property allows you to open up a cursor on the server. SQL Options must have the soPackets set to True also. The initial fetch will return RowsToReturn rows, and then the dataset on the server will stay active allowing calls to GetNextPacket. You can close the Query on the server by calling CloseQueryOnServer.