Working with Commands (FireDAC)

From RAD Studio
Jump to: navigation, search

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.