The reference to DatS table object, actually representing the internal data storage.
The Table property returns reference to TADDatSTable object. It is the internal data storage containing all dataset rows.
AnyDAC creates table for each dataset automatically at Open. TADCustomMemTable allows to attach to existing table before Open call, using AttachTable method. If table was automatically created, then it will be destroyed after dataset closing.
As result of applying of filters, indexes and ranges, AnyDAC builds views for this table object. All dataset navigation methods does not work with table, but with SourceView view object.
property Table: TADDatSTable;
var i: Integer; .... // delete all rows, where ID = 100, without navigating through dataset for i := ADQuery1.Table.Rows.Count - 1 downto 0 do if ADQuery1.Table.Rows[i].GetData('id') = 100 then ADQuery1.Table.Rows[i].Delete; ADQuery1.Resync();
What do you think about this topic? Send feedback!