Escape sequences allow for writing DBMS-independent SQL commands. The sample predefines some escape function sequences. To execute a predefined escape function, right-click the Function edit box and choose a predefined escape function from the popup menu. Moreover, the sample allows you to write your own function. To this end, write text into the Function edit box and press Enter. Then, the…
FireDAC Tip: Learn How to Manage Centralized Cached Updates With This Schema Adapter Sample
February 4, 2021
The FireDAC.SchemaAdapterMemTable Sample uses some methods and properties ofTFDSchemaAdapterin order to implement some features related with the management ofCentralized Cached Updates.
Location
You can find theSchemaAdapterMemTablesample…
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…
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…
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…
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…
