FireDAC.Comp.Client.TFDCustomCommand.Fetch

• Up to Parent: TFDCustomCommand

procedure Fetch(ATable: TFDDatSTable; AAll: Boolean = True; ABlocked: Boolean = False); overload;

void __fastcall Fetch(Firedac::Dats::TFDDatSTable* ATable, bool AAll = true, bool ABlocked = false)/* overload */;

Properties

Description

Fetches rows from the current command cursor.

The Fetch method fetches rows from the current command cursor in the DatS table. To call Fetch, the command must be opened (in csActive state) by a call to Open, otherwise an exception is raised.

At each call up to FetchOptions.RowsetSize rows are fetched. If FetchOptions.AutoClose is True, FireDAC automatically calls the CloseAll method after fetching the last row.

If fiBlobs is in FetchOptions.Items, then the values of the BLOB field are fetched together with other field values. If fiDetails is in FetchOptions.Items, then the nested dataset is fetched together with other field values. While fetching, the field values are converted according to FormatOptions and stored into the DatS rows.

Example

var
 oTab: TADDatSTable;
...
 ADCommand1.CommandKind := skStoredProc;
 ADCommand1.CommandText.Text := 'SEL_CUST_PROC';
 oTab := ADCommand1.Define;
 try
 ADCommand1.Open;
 repeat
 oTab.Clear;
 ADCommand1.Fetch(oTab, False);
 // process next rowset
 until ADCommand1.RowsAffected = 0;
 finally
 oTab.Free;
 end;

See Also

• FireDAC.Stan.Option.TFDFetchOptions
• FireDAC.Comp.Client.TFDCustomCommand.Close
• FireDAC.Comp.Client.TFDCustomCommand.CloseAll
• FireDAC.Comp.Client.TFDCustomCommand.Open
• FireDAC.Comp.Client.TFDCustomCommand.Active

Sample

• FireDAC TFDMemTable Incremental Fetching sample

• API Documentation
• XE5