Working with Commands (FireDAC)

Go Up to FireDAC

This section contains a set of articles describing how to execute SQL commands with FireDAC, exchange data and metadata.

Topic	Description
Preprocessing Command Text	FireDAC offers powerful SQL command text preprocessor. It allows you to write DBMS-independent SQL commands and to get more flexibility while building dynamic SQL commands. The preprocessor features include substitution variables, escape sequences, escape functions, and conditional escapes.
Executing Commands	FireDAC offers TFDQuery, TFDCommand components, and some TFDConnection methods to execute SQL commands. The SQL commands are the main way to talk to SQL database.
Executing Stored Procedures	FireDAC offers the TFDStoredProc component to execute database stored procedures, as a stored procedure may be executed directly.
Browsing Tables	FireDAC offers the TFDTable component to browse database table data, filter and sort records, and edit the table data.
Database Alerts	FireDAC offers the TFDEventAlerter component to listen for database alerts, send the alerts and manage them.
Data Change Notifications	FireDAC offers advanced application of the TFDEventAlerter component to track changes in data.
Fetching Rows	When a SQL command is executed, it may create a cursor returning the result set. FireDAC offers a wide range of features to effectively process the cursor and fetch rows into the client records cache.
Command Batches	FireDAC supports SQL command batches that allow executing multiple SQL commands in a single step and processing multiple result sets in a sequence.
Array DML	FireDAC offers high-performance Array DML feature. It allows moving large volumes of data to a database using standard INSERT or UPDATE SQL commands.
Performance of the Array DML	Describes the high performance of the Array DML feature. This article will lead you through an easy example that shows how to insert thousands of records per second by writing just a few lines of code.
Asynchronous Execution	FireDAC offers multiple features for asynchronous operation execution. In addition to being ready for use in multi-threaded applications, FireDAC makes it easy for the developer to work with multi-threading in the first place, as it allows controlling the timing aspects of the data access operation execution. This includes the Execute, Open, and Fetch operations.
Executing SQL Scripts	Most database applications have back-end administration utilities, which must execute SQL script. These scripts are written using lines appropriate to the DBMS SQL script syntax. TFDScript is the FireDAC SQL script processor.
Local SQL	FireDAC offers flexible Local SQL features. It allows executing SQL queries against TDataSet descendants as data sources.
BLOB Streaming	FireDAC offers BLOB streaming features. It allows optimizing the large data exchange with the database.