Topic 

Description 

Preprocessing Command Text 

AnyDAC offers powerful SQL command text preprocessor. Allowing to write DBMS independent SQL commands and to get more flexibility while building dynamic SQL command. The preprocessor features include substitution variables, escape sequences, escape functions and conditional escapes. 

Executing Command 

AnyDAC offers TADQuery, TADCommand components and some TADConnection methods to execute SQL commands. The SQL commands are the main way to talk to SQL database. 

Executing Stored Procedure 

AnyDAC offers TADStoredProc component to execute database stored procedures, as a stored procedure may be executed directly. 

Browsing Table 

AnyDAC offers TADTable component to browse database table data, filter and sort records, and edit the table data. 

Database Alerts 

AnyDAC offers the TADEventAlerter component to listen for database alerts, send the alerts and manage them. 

Fetching Rows 

When a SQL command is executed it may create a cursor returning the result set. AnyDAC offers wide range of features to effectively process the cursor and fetch rows into the client records cache. 

Command Batches 

AnyDAC supports SQL command batches. Command batches allowing to execute multiple SQL commands in a single step and to process multiple result sets in a sequence. 

Array DML 

AnyDAC offers high performance Array DML feature. It allows to move large volumes of data to a database using standard INSERT or UPDATE SQL commands. 

Asynchronous Execution 

AnyDAC offers multiple features for asynchronous operation execution. In addition to being ready for use in multi-threaded applications, AnyDAC makes it easy for the developer to not have to worry about multi-threading in the first place by allowing you to control the timing aspects of the data access operation execution. This includes Execute, Open and Fetch operations. 

Executing SQL Scripts 

Most database applications have backend administration utilities, which must execute SQL script. These scripts are written using lines appropriate to the DBMS SQL script syntax. TADScript is the AnyDAC SQL script processor. 

Local SQL 

AnyDAC offers flexible Local SQL feature. It allows to execute SQL queries against TDataSet descendants as the data sources.