TheCachedUpdatessample shows you how to work with theTFDMemTableclass. To this end,TFDMemTableretrieves data from a database throughTFDTableAdapterandTFDCommand. Then, the sample uses some methods and properties ofTFDTableAdapterin order to implement some features related with the management ofCached…
Powerful Financial Robo-Analyst Software For The Likes Of BitCoin, GameStop, BlackBerry, And AMC Is Built With Delphi
January 29, 2021
Robo-Analyst is a powerful financial software that gives an instant analysis on more than 16,000 stocks, funds, and cryptocurrencies and it is built with Delphi. According to Robo-Analyst their advanced software analyzes and interprets the most widely-used indicators; with a…
Quickly Learn How To Fetch A Table Using FireDAC In This IFDPhysCommand Delphi Sample
January 26, 2021
The sample uses theIFDPhysCommandinterace tofetch rowsfrom the current command cursor in theDatStable. To this end, the samplecreates a commandinterface to:
PrepareaSELECTcommand.Definethe structure…
Quickly Define Powerful Client-Side Aggregating Formulas With FireDAC Using TFDQuery In Delphi
January 24, 2021
This sample demonstrates how to define the client-side aggregating formulas with TFDQuery. You can find out more about aggregated fields and values in the Embarcadero DocWiki.
The fkAggregate aggregated fields management is similar to the expression calculated fields management. FireDAC calculates aggregated fields when TFDDataSet.AggregatesActive is set to True (by default, its value is…
Master A Powerful Way To Execute Multiple SQL Commands In Delphi With This Windows Sample
January 22, 2021
This sample demonstrates two ways ofhandling errorsin anarray DML execution.
To this end, the sample implements two ways of handling the errors:
Implementing anOnErrorevent.Using theEFDDBEngineExceptionclass on a…
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…
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 emptyDatabaseparameter value). TheTFDLocalSQLcomponent is for the Local SQL engine.
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 | Embarcadero RAD Studio Sydney | Samples and then navigate to: Object PascalDatabaseFireDACSamplesPhys…