FireDAC.Comp.DataSet.TFDDataSet.Table

From Appmethod Libraries
Jump to: navigation, search

Object Pascal

property Table: TFDDatSTable read FTable;

C++

__property Firedac::Dats::TFDDatSTable* Table = {read=FTable};

Properties

Type Visibility Source Unit Parent
property public
FireDAC.Comp.DataSet.pas
FireDAC.Comp.DataSet.hpp
FireDAC.Comp.DataSet TFDDataSet

Description

Specifies the reference to the DatS table object, representing the internal data storage.

The Table property returns a reference to the TFDDatSTable object. It is the internal data storage containing all dataset rows. 

FireDAC creates a table for each dataset automatically when Open is called. TFDCustomMemTable allows to attach the existing table before Open is called, by using the AttachTable method. If the table was automatically created, then it will be destroyed after the dataset is closed. 

As a result of applying filters, indexes, and ranges, FireDAC builds views for this table object. All dataset navigation methods use SourceView view objects to get access to the table rows.

Example

var
  i: Integer;
....
// delete all rows, where ID = 100, without navigating through dataset
for i := FDQuery1.Table.Rows.Count - 1 downto 0 do
  if FDQuery1.Table.Rows[i].GetData('id') = 100 then
    FDQuery1.Table.Rows[i].Delete;
FDQuery1.Resync([]);

See Also