RAD Studio 10.4.1 is now available! Learn more. Looking for discounts? Visit our Special Offers page!
CodeDatabaseDelphiRAD Studio

Learn How To Use FireDAC To Work With A Firebird Database In Delphi

The Firebird getting started sample shows how to use FireDAC with Firebird databases. This sample allows the user to do:

  • Temporary connection definition at run time.
  • Master-details relationship between datasets using TFDQuery.
  • Transactions handling with TFDTransaction.
  • Management of Firebird database such as: managing users, creating database backup/restoring database from backup and validating a database.

Location

You can find the Firebird sample project at:

  • Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
    • Object Pascal\Database\FireDAC\Samples\Getting Started\Firebird
  • 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 GettingStarted.dproj.
  2. Press F9 or choose Run > Run.

Files

File in DelphiContains
GettingStarted.dproj
GettingStarted.dpr
The project itself.
fGettingStarted.pas
fGettingStarted.fmx
The main form.

Implementation

The sample implements the following features.

Creating temporary connection definition

The simplest way to configure connection to Firebird database at run time is to build a temporary connection definition:

In the sample the temporary definition is created when the Connect button is clicked.

Master Details

In this sample, the Categories and Products tables have one-to-many relation by CategoryID field. The qryCategories.SQL property is set up as follows:

In addition, the qryProducts.SQL property is set up as follows:

Finally, the qryProducts.MasterSource property is set to dsCategories, while the MasterFields property is set to CategoryID. This creates a master-details relationship between the datasets.

Transaction handling

Handling of InterBase transactions is demonstrated using TFDTransaction + TFDConnection components. Both are configured as follows: trnMain.Connection property is set to dbMain connection and dbMain.Transaction property is set to trnMain.

Starting a transaction:

Committing the transaction:

Rolling back the transaction:

Executing queries

Simple queries execution is demonstrated via ExecSQL method of TFDConnection.

Updating records:

Getting a scalar value from the database:

Service work with Firebird database

The sample performs the following management of databases:

  • Security management.
  • Database maintenance.
  • Tracing server activity

All the management of databases is done using the following components TFDIBBackupTFDIBRestoreTFDIBRestoreTFDIBSecurityTFDIBTrace and TFDIBValidate.

This demo demonstrates work with TFDIBBackupTFDIBRestoreTFDIBSecurity and TFDIBValidate components:

In the link below you can find more information about this sample and links to other samples:

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


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++CodeDelphi

Manage Your Collection Of Pages Easily With TCardPanel Component For Your Delphi VCL Application

CodeDelphiRAD Studio

Learn How To Use FireDAC In The Dynamic-Link Libraries With DLL Sharing Sample In Delphi

C++CodeDelphi

Learn To Build A Python GUI For Working with HTTP Requests With Requests Library In A Delphi Windows App

DelphiShowcase

Lovingly Crafted Software To Plan And Simulate Virtual Model Railroads Is Built In Delphi

Leave a Reply

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

IN THE ARTICLES