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

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

To this end, the sample uses the CliHandle and SharedCliHandle properties of the TFDConnection class.

Location

You can find the DLLSharing sample project at:

  • Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
    • Object PascalDatabaseFireDACSamplesComp LayerTFDConnectionDLL_Sharing
  • 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 Project1.dproj.
  2. Press F9 or choose Run > Run.

Files

File in DelphiContains
Project1.dproj
Project1.dpr
The project itself.
Unit1.pas
Unit1.fmx
The main form.
Project2.dproj
Project2.dpr
The DLL.
Unit2.pas
Unit2.fmx
The DLL form.

Implementation

The sample uses FireDAC to implement a connection with a dynamic-link library. To this end, the sample implements three buttons named: Button1Button2 and Button3. Each button handles a OnClick event to implement the following features:

  • Load a DLL
  • Show data
  • Unload the DLL

Load DLL

To transfer a connection between an application and a DLL, the sample transfers the TFDCustomConnection.CliHandle property value to the DLL. The handle must be assigned to the TFDCustomConnection.SharedCliHandle property.

After the TFDCustomConnection.SharedCliHandle is assigned, the DLL connection can be activated by setting the Connected property to True. Note that there is no need to set up a connection definition, including DriverID.

Show data

Then, the connection can be used as a normal database connection:

Unload DLL

To unload the dynimic-link library, the sample implements the following code:

Head over and check out the full sample source code for DLL sharing with FireDAC in Delphi.


What's New for RAD Studio 11

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
CodeDelphi

5 Ways To Improve Your Code: What You Need To Know

DelphiDeveloper InterviewsInterviewNews

What Is It Like To Be A Developer Dalija Prasnikar?

DelphiRAD Studio

This Is How To Modernize Your Apps On Time And Under Budget

DelphiNewsRAD Studio

Delphi Best Practices For A New Project In 2021 And Beyond

Leave a Reply

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

IN THE ARTICLES