This sample shows the use of FireDAC database connection using SQLite. Also, it shows how to use a TBindNavigator control.

Location

You can find the FMGettingStarted project at:

• Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
  • Object PascalDatabaseFireDACSamplesGetting Started FMXSQLite_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.

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

Implementation

• The project uses a TFDConnection that establishes a connection with a database. In this case FDDemo.sdb which can be found at Samples > data > FDDemo.sdb. In order to navigate through the data, the project uses TFDQuery, TDataSource, TFDPhysSQLiteDriverLink, TFDGUIxLoginDialog, TFDGUIxWaitCursor and TBindNavigator.
• The TFDQuery executes a SELECT query against the Territories table.
• The application also uses a TStringGrid to display the database’s data.

If you would like to check the original post of Embarcadero, please visit the link below:

http://docwiki.embarcadero.com/CodeExamples/Sydney/en/FireDAC.SQLite_Desktop_Sample

Head over and check out all of the source code for the SQLite sample app for Windows in Delphi.

---

Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

---