This sample allows the user to create a temporary connection definition at run-time and the master-details relationship between datasets using TFDQuery to work with MSSQL databases.
Table of Contents
Location
You can find the MSSQL sample project at:
- Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
Object PascalDatabaseFireDACSamplesGetting StartedMSSQL
- Subversion Repository:
- You can find Delphi code samples in GitHub Repositories. Search by name into the sample repositories according to your RAD Studio version.
How to Use the Sample
- Navigate to the location given above and open
GettingStarted.dproj. - Press F9 or choose Run > Run.
Files
| File in Delphi | Contains |
|---|---|
GettingStarted.dprojGettingStarted.dpr | The project itself. |
fGettingStarted.pasfGettingStarted.fmx | The main form. |
Implementation
The sample implements the following features.
Creating temporary connection definition
The simplest way to configure the connection to the MS SQL database at run-time is to build a temporary connection definition:
[crayon-6767930c16ef4574088762/]In the sample, the temporary definition is created when clicking the Connect button.
Master Details
In the demo database, the Categories and Products tables have one-to-many relations by CategoryID field. The qryCategories.SQL property is set up as follows:
In addition, the qryProducts.SQL property is set up as follows:
[crayon-6767930c16efc409202623/]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.
Executing queries
Simple query execution is demonstrated via ExecSQL method of TFDConnection.
Inserting a record providing parameters of various types:
[crayon-6767930c16efe742117414/]Updating records:
[crayon-6767930c16eff549693205/]Deleting a record:
[crayon-6767930c16f00105033841/]Getting a scalar value from the database:
[crayon-6767930c16f01417278799/]If you want to check the original post of this sample, please visit the link below:
http://docwiki.embarcadero.com/CodeExamples/Sydney/en/FireDAC.MSSQL_Sample
You may quickly install servers on Windows operating systems using IDE software. This may help you connect to the Microsoft SQL Server, when developing in Delphi and C++ environments. You can request a free demo here.