From RAD Studio API Documentation
Jump to: navigation, search


property DataSets;


__property DataSets;


Type Visibility Source Unit Parent
property published
FireDAC.Phys.SQLiteVDataSet TFDLocalSQL


Collection of the registered datasets.

FireDAC.Phys.SQLiteVDataSet.TFDLocalSQL.DataSets inherits from FireDAC.Comp.Client.TFDCustomLocalSQL.DataSets. All content below this line refers to FireDAC.Comp.Client.TFDCustomLocalSQL.DataSets.

Collection of the registered datasets.

Use the DataSets collection property to manage the datasets registered with this Local SQL engine.

You can add FireDAC datasets to the collection implicitly, by setting the LocalSQL property. You can add non-FireDAC and FireDAC datasets explicitly by adding new items to the DataSets collection. To remove a dataset from the list of registered datasets, remove the corresponding item from the DataSets collection. You can add or remove datasets both at design time and at run time.

All datasets in the collection must have unique names. When an item's Name property is specified, then it is used as a dataset name. If not specified, then a TDataSet.Name value is used.


ADLocalSQL1.DataSets.Add.DataSet := ADOQuery1;
ADLocalSQL1.DataSets.Add.DataSet := ADOQuery2;
ADQuery1.LocalSQL := ADLocalSQL1;
ADQuery2.LocalSQL := ADLocalSQL1;

See Also