FireDAC is Embarcadero’s library for universal data access – connection to just about any database protocol you can find. It abstracts the protocol-level details and presents a common interface so developers can build their applications to be database agnostic and flexible in the event of future design changes.
My work this week focused on FireDAC and local databases. SQLite is…
Build High-Speed Direct Access Apps In Delphi And C++Builder To Most Modern Databases Using FireDAC
October 26, 2020
FireDAC is a unique set of Universal Data Access Components for developing multi-device database applications for Delphi and C++Builder. With its powerful common architecture, FireDAC enables native high-speed direct access from Delphi to InterBase, SQLite, MySQL, SQL…
TheMacrossample shows you how to use theMacrosproperty ofTFDQueryin order to parameterize parts of the SQL query. The sample allows you to modify the macro values at run time.
Location
You can find theMacrossample project…
Optimize Database Population Performance With Array DML In Delphi
October 25, 2020
This sample demonstrates how to use Array DML in FireDAC and compares its performance for different array sizes.
Location
You can find theArrayDMLsample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samplesand then navigate…
Learn How To Create A Custom List View Adapter With A Python Server In This Sample For Delphi
October 23, 2020
Location
You can find theCustomAdaptersample project at:
Start | Programs | Embarcadero RAD Studio Sydney | Samplesand navigate to:Object Pascal\Multi-Device Samples\User Interface\ListView\CustomAdapterSubversion Repository:You can find Delphi code…
The FireDAC.TFDLocalSQL MegaFMX sample is divided in three tabs where each tab demonstrates single Local SQL usage case.
Each tab has dedicated SQLite in-memory connection established using theTFDConnectionwith only single parameterDriverID=SQLite. When…
Building a C++ VCL Customer/Sales Master/Detail/Charting Application with 1 Line of Code
October 22, 2020
You may have read or heard about No Code and Low Code application development using systems, languages and run times. Atanas Popov, GM of Embarcadero Technology, recently blogged about low code development. “These days low-code development is en vogue. Various research…
TheBatchsample shows you how to useArray DMLto execute multiple SQL INSERT commands in a single step to optimize database population performance. In this demo the “batch” and “Array DML” terms are…
UDF is a User Defined Functions in InterBase. They are similar to stored procedures. The difference is that instead of writing stuff in SQL and execute it in the database, we are loading functionality from DLLs.
In this CodeRage session, you will learn how to create…
This sample uses theConnectionDefNameproperty of theTFDConnectionto specify the name of the connection definition to use.
Location
You can find theTFDConnection\InfoReportsample project at:
Start | Programs | Embarcadero RAD…
