Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!
CodeDelphiRAD Studio

Easily Connect To SQLite Using FireDAC And LiveBindings In Delphi

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

FileContains
FMGettingStarted.dprojContains the project itself.
MainFrm.fmxContains the main form code.
MainFrm.pascontains the main form and the main code.

Implementation

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

Related posts
C++CodeIDE

10 Creative Ways To Develop Awesome C++ Apps On Windows

DelphiIDERAD Studio

Everything You Need To Know About An IDE For Coding

C++Delphi

Why You Should Think About Analytics And Reporting Tools

DatabaseDelphiTech Partner

This Is How To Use ADO And FireDAC With Databases

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES