DELETE (POSITIONED)
Deletes the row most recently fetched by a DataRows cursor.
DELETE (SEARCHED)
Removes the DataRows that meet the row state and/or search criteria from the named DataTable.
FETCH
Transfers all or a subset of a DataRows cursor into host variables or host arrays.
FILL
Adds new DataRows to (or refreshes the existing DataRows of) the DataTables in a DataSet using data from the data source.
GET CHANGES
Creates a new DataSet containing only DataRows that have been modified (deleted, added or changed).
GET CONNECTION Places the current OpenESQL connection and transaction objects into the supplied host variables such that the objects can then be shared with other ADO.NET programs.
GET CURSOR
Places a DataReader or a DataSet ADO.NET object used by the OpenESQL EXEC SQL cursor into the supplied host variable such that the object can then be shared with other ADO.NET programs.
GET DATATABLE
Copies a DataTable object into a host variable or creates a DataTable object within a host variable, enabling you to share the DataTable object with other .NET languages.
GET RUNTIME
Places the current OpenESQL MFADORTS object into the supplied host variable.
INITIALIZE DATASET
Creates an empty DataSet for a previously declared one and optionally stores a reference to that DataSet.
INITIALIZE DATATABLE
Creates an empty DataTable for a previously declared one, and optionally stores a reference to that DataTable.
INSERT
Adds new DataRows to a DataTable. It is similar to the EXEC SQL INSERT statement which adds new rows into a SQL table.
LOAD DATASET
Loads a DataSet that has been stored as an XML file and provides addressability to the corresponding ADO.NET DataSet.
LOAD DATATABLE
Either loads a DataTable from an XML file, or uses a cursor to load a DataTable. Also provides addressability to the corresponding ADO.NET DataTable.
MERGE
Merges new data into a target DataSet or DataTable.
PREPARE TO FILL
Begins the process of loading the DataTables in a DataSet from a data source.
PREPARE TO UPDATE
Begins the process of updating a data source with changes made in the DataTables of a DataSet.
REBIND CONNECTION
Informs OpenESQL that a shared connection transaction has been terminated and supplies a new transaction object for subsequent processing.
REJECT CHANGES
Rolls back all pending changes made in the DataTables of a DataSet.
SAVE DATASET
Saves the schema and data of a DataSet to an XML file.
SAVE DATATABLE
Saves the data and optionally the schema of a DataTable to an XML file.
SELECT INTO
Retrieves one or more DataRows from a DataTable into host variables or host arrays, enabling you to select information from a DataTable without declaring a DataRows cursor.
TO DELETE USE
Specifies, for a specific DataTable, the SQL logic necessary to make deletes from a data source.
TO FILL USE
Specifies, for a specific DataTable, the SQL logic necessary to load the columns of that DataTable with data from a data source.
TO INSERT USE
Specifies, for a specific DataTable, the SQL logic necessary to make inserts into in a data source.
TO REFRESH USE
Specifies, for a specific DataTable, the SQL logic necessary to refresh the rows of a DataTable, showing the changes made to the data source after the UPDATE DATASOURCE statement was executed.
TO UPDATE USE
Specifies, for a specific DataTable, the SQL logic necessary to make updates to a data source.
UNBIND
Disassociates OpenESQL from a DataSet or DataTable in another ADO.NET application.
UNBIND CONNECTION
Disassociates OpenESQL from the original ADO.NET connection object.
UPDATE
Updates a data source with changes made in the DataTables of a DataSet.
UPDATE (POSITIONED)
Updates the DataRow most recently fetched by using a DataRows cursor.
UPDATE (SEARCHED)
Updates a DataTable either by using a standard SQL WHERE clause or by replacement via a host variable array.
USING
Specifies the current DataSet name to be used in subsequent processing.
