Delphi Cookbook - Third Edition

How to do it...

Let's look at the following steps:

1. Create a new VCL application by selecting File | New | VCL Forms Application.
2. Put a TFDConnection on the form and set its DriverName to SQLite (because SQL Local uses SQLLite in its engine).

3. Place on the form a DBEdit (aligned to the top), a TButton (aligned to the top), a DBNavigator (aligned to the top), a DBGrid (aligned to the client), and a DataSource. Set the DataSource property of DBNavigator1 and DBGrid1 to DataSource1.
4. From DataExplorer, drag and drop onto the form the SALES table from the DELPHICOOKBOOK connection under the InterBase voice.
5. Now, put on the form one TFDQuery, one TFDLocalSQL, and one TClientDataSet.
6. It's time to rename components:

Old	New
FDQuery1	LocalQuery ...