FireDAC.Phys.SQLiteVDataSet.TFDLocalSQL
Delphi
TFDLocalSQL = class(TFDCustomLocalSQL)
C++
class PASCALIMPLEMENTATION TFDLocalSQL : public Firedac::Comp::Client::TFDCustomLocalSQL
Contents
Properties
Type | Visibility | Source | Unit | Parent |
---|---|---|---|---|
class | public | FireDAC.Phys.SQLiteVDataSet.pas FireDAC.Phys.SQLiteVDataSet.hpp |
FireDAC.Phys.SQLiteVDataSet | FireDAC.Phys.SQLiteVDataSet |
Description
The class implementing the SQLite-based Local SQL engine.
The Connection property points to a SQLite connection object which will provide the ability to execute the Local SQL commands. To activate the engine, set Active to True.
The FireDAC datasets can be registered with the engine by setting their LocalSQL properties. FireDAC and non-FireDAC datasets can be registered with the engine using the DataSets collection property. To remove the dataset, delete the corresponding collection item. To dynamically discover and register datasets, use the OnGetDataSet event handler.
To group the dataset objects into a schema, set the SchemaName property. To disable the dataset cloning or copying, set the MultipleCursors property to False. To enable events of a TDataSource associated with a base dataset, set DisableControls to False. To exclude invisible fields from the Local SQL result sets, set IncludeHiddenFields to False.
Example
FDConnection1.DriverName := 'SQLite';
FDLocalSQL1.Connection := FDConnection1;
FDLocalSQL1.SchemaName := 'orders';
FDLocalSQL1.DataSets.Add.DataSet := adoQOrders;
FDLocalSQL1.DataSets.Add.DataSet := qDetails;
FDQuery1.Connection := FDConnection1;
FDQuery1.Open('select * from orders.adoQOrders o left join orders.qDetails d on o.OrderID = d.OrderID');
See Also
- Local SQL engine
- FireDAC.Comp.Client.TFDCustomLocalSQL.Connection
- FireDAC.Comp.Client.TFDAdaptedDataSet.LocalSQL
- FireDAC.Comp.Client.TFDCustomLocalSQL.DataSets
- FireDAC.Comp.Client.TFDCustomLocalSQL.OnGetDataSet
- FireDAC.Phys.SQLiteVDataSet.TFDLocalSQL.SchemaName
- FireDAC.Phys.SQLiteVDataSet.TFDLocalSQL.MultipleCursors
- FireDAC.Phys.SQLiteVDataSet.TFDLocalSQL.DisableControls
- FireDAC.Phys.SQLiteVDataSet.TFDLocalSQL.IncludeHiddenFields