FireDAC.SQLite Desktop Sample

From RAD Studio Code Examples
Jump to: navigation, search

This sample shows the use of FireDAC database connection using SQLite.


You can find the FMGettingStarted project at:

  • Start | Programs | Embarcadero RAD Studio Alexandria | Samples and then navigate to:
    • Object Pascal\Database\FireDAC\Samples\Getting Started FMX\SQLite_Desktop
  • Subversion Repository:
    • You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.


  • The demo shows how to connect to a database using FireDAC and LiveBindings. Also, it shows how to use a TBindNavigator control.

Note: The default database has no password.

How to Use the Sample

  1. Navigate to the location given above and open FMGettingStarted.dproj.
  2. Press F9 or choose Run > Run.
  3. Click the Open button and the database's data will appear in the grid.
  4. Choose a database and enter your password or use the default database which has no password.
  5. Navigate through the data using the TBindNavigator.


File Contains


Contains the project itself.


Contains the main form code.


contains the main form and the main code.


  • The TFDQuery executes a SELECT query against the Territories table.
  • The application also uses a TStringGrid to display the database's data.


See Also