From RAD Studio API Documentation
Jump to: navigation, search


property DataSets: TFDLocalSQLDataSets read FDataSets write SetDataSets stored False;


__property TFDLocalSQLDataSets* DataSets = {read=FDataSets, write=SetDataSets, stored=false};


Type Visibility Source Unit Parent
property public
FireDAC.Comp.Client TFDCustomLocalSQL


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