Allows an ADO.NET DataSet or DataTable to be shared with OpenESQL.
Syntax:
>>--EXEC ADO---.--------------------------.-BIND TO :dataobject_hv-------->
+-USING dataset_name-------+
+-DATATABLE datatable_name-+
>--.-------------------.---END-EXEC----><
+-WITH SCHEMA CHECK-+
Parameters:
dataset_name
|
The name of the DataSet to be used, or - (dash), which specifies a standalone DataSet. If you do not specify dataset_name,
the current DataSet is used.
|
datatable_name
|
The name of the DataTable you want to share with OpenESQL.
|
dataobject_hv
|
Host variable which identifies an ADO.NET DataSet or DataTable object.
|
WITH SCHEMA CHECK
|
Runtime check that verifies that the current schema is the same as one declared at compile-time.
|
Examples:
EXEC ADO
USING changesDS BIND TO :changesDSobj
END-EXEC
EXEC ADO
BIND DATATABLE TABLE1 TO :HVCHGS
END-EXEC
Comments:
Subsequent EXEC ADO statements in OpenESQL referencing dataset_name (or the current OpenESQL DataSet if dataset_name is not specified) use the current ADO.NET DataSet if it has been defined.