FireDAC.SQLite Desktop Sample

From RAD Studio Code Examples
Jump to: navigation, search

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

Location

You can find the FMGettingStarted project at:

Description

  • 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.

Files

File Contains

FMGettingStarted.dproj

Contains the project itself.

MainFrm.fmx

Contains the main form code.

MainFrm.pas

contains the main form and the main code.

Implementation

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

Uses

See Also

Tutorials

Personal tools
Assistance