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 |…
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 |…
Power Tip: Learn How to Send Arrays To An InterBase Database Using FireDAC In Delphi
January 13, 2021
The Arrays sample shows you how to use the TFDParam.ArrayType property to send arrays to a database server. To this end the ArrayType property is set to atTable.Note: This demo establishes a connection to the Interbase localhost server by default, using…
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 |…
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…
This sample shows how to use FireMonkeyimage lists. In theUsing TImageList Image Lists as Centralized Collections of Imagestutorial, this example is used:
Todemonstrate how to usetheImage List Editor.To describe the code implementing…
It displays a picture, which the user can rotate by pressing it with two fingers and rotating them. The image rotates in the direction that your fingers are pointing. The image rotates to the right when the fingers are rotated to the right. The image rotates to the left when…
