OpenESQL supports two types of data tables in ADO.NET - data tables inside data sets, and free-standing data tables. The EXEC
ADO operations available for each type differ in the way data tables are specified in their syntax. For example, EXEC ADO
statements that apply to free-standing data tables contain a DATATABLE keyword in their syntax. Those that apply to data tables
within data sets contain an optional USING clause.
EXEC ADO statements that support free-standing data tables
- DECLARE DATATABLE
- GET CURSOR
- GET DATATABLE
- INITIALIZE DATATABLE
- LOAD DATATABLE
- MERGE
- SAVE DATATABLE
- UNBIND
EXEC ADO statements that support data tables within data sets
- ACCEPT CHANGES
- BIND
- CLEAR
- DECLARE DATAROWS
- DELETE (POSITIONED)
- DELETE (SEARCHED)
- GET CHANGES
- GET DATATABLE
- INITIALIZE DATASET
- INSERT
- LOAD DATASET
- LOAD DATATABLE
- MERGE
- PREPARE TO FILL
- PREPARE TO UPDATE
- REJECT CHANGES
- SAVE DATASET
- SAVE DATATABLE
- SELECT INTO
- TO DELETE USE
- TO FILL USE
- TO INSERT USE
- TO REFRESH USE
- TO UPDATE USE
- UNBIND
- UPDATE (POSITIONED)
- UPDATE (SEARCHED)
See the
Embedded ADO Statements reference section for details on each statement.