Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADDataSet.GetNextPacket Method
TADDataSet Class  TADDataSet Members  uADCompDataSet Namespace  Example  public  See Also  Send Feedback

Fetches the next rowset from the DBMS.

Group

public

Links
TADDataSet Class, TADDataSet Members, uADCompDataSet Namespace, Example, public, See Also
Returns

The number of fetched records.

Description

Call GetNextPacket to fetch the next rowset from a DBMS cursor. 

To specify the maximum number of records to return in a rowset, set the FetchOptions.RowsetSize property before calling GetNextPacket. A rowset is appended to those records already stored in the internal data storage. 

GetNextPacket returns the number of records fetched. If the return value is less than FetchOptions.RowsetSize, the dataset has already received all available records from the DBMS cursor. 

Use GetNextPacket for manual fetching mode, when FetchOptions.Mode = fmManual.

Syntax
function GetNextPacket: Integer;
See Also
Example
ADQuery1.FetchOptions.Mode := dmManual;
ADQuery1.SQL.Text := 'select * from mytab';
ADQuery1.Open;
// here RecordCount = 0
ADQuery1.GetNextPacket;
// here RecordCount <= FetchOptions.RowsetSize
What do you think about this topic? Send feedback!