TheOnUpdateRecordsample shows you how to cache the user changes when using read-only dataset and then, how to apply updates on behalf of queries that cannot post updates directly. To this end, the sample uses theOnUpdateRecordevent ofTFDQueryand theTFDUpdateSQLobject.
Location
You can find theCentralizedCachedUpdatessample project…
The sample shows in a nice way how to use theTFDLocalSQLcomponent to execute SQL commands on in-memory database, represented by several TFDMemTables.
This sample uses aTFDConnectionto connect to the SQLite in-memory database (with…
Quickly Set Up Flexible Master-Detail Relationships Between Datasets In Delphi Apps
January 18, 2021
The sample uses the master-detail relationship to automatically filter a detail dataset based on a current master dataset record. In this sample, the master dataset has “Order” records, and the detail dataset shows only lines for the current order. Moreover, the…
Learn How Easy It Is To Connect To Microsoft SQL Server In Windows Delphi Development
January 17, 2021
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.
Location
You can find theMSSQLsample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to: Object PascalDatabaseFireDACSamplesGetting StartedMSSQL…
Learn More About The Powerful Macros Property Of IFDPhysCommand With FireDAC In Delphi
January 16, 2021
The sample allows you to modify the macro values at run time.Note: See thePreprocessing Command Texttopic for more information about parameterizing SQL command texts.
Location
You can find theMacrossample project at:
Start | Programs |…
Powerful Video Game Collection Curation Software Is Built In Delphi
January 15, 2021
Game Collector is a powerful video game game collection database software and it is built in Delphi. According to the developer’s website Game Collector’s main screen is highly customizable, so that you can make it look the way you want. You can choose between…
QuickLib Is A Powerful Third Party Library For Delphi Which Can Boost Productivity
January 14, 2021
Most of the time when starting a new big project you end up creating lots of modules for your application. Most of them could be dozens of different functions which helps to write less code while building the main project. For instance, while I was developing a school management system, I have created more than 30 modules for my project and currently, I utilize them all the time. They are my core…
Easily Connect To SQLite Using FireDAC And LiveBindings In Delphi
January 12, 2021
This sample shows the use ofFireDACdatabase connection usingSQLite. Also, it shows how to use aTBindNavigatorcontrol.
Location
You can find theFMGettingStartedproject at:
Start | Programs | Embarcadero RAD Studio Sydney |…
NuSphere PhpED is a powerful native Windows IDE for PHP and it is built in Delphi. According to the developer’s site it handles PHP, HTML, CSS, XML, SMARTY, XHTML, and more. Additionally, they state that it has a balanced combination of advanced code editor, reliable…
Learn How To Define Powerful Dataset Views Using Indices With FireDAC In Delphi Windows Development
January 11, 2021
The Indices sample shows you how to use the Indexes property of TFDQuery in order to specify a collection of indexes at design time and determine the data view of each index, including a sort order of the records. Moreover, you can sort the records on a specific field using the IndexFieldNames property. Click on a grid column title to sort its records at run time.
Location
You can…
