Previous Topic Next topic Print topic


BIND

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.

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.

Examples:

     EXEC ADO
        USING changesDS BIND TO :changesDSobj
     END-EXEC

     EXEC ADO 
        BIND DATATABLE TABLE1 TO :HVCHGS  
     END-EXEC
Previous Topic Next topic Print topic