Generated EXEC ADO Statements

OpenESQL Assistant can generate the following types of EXEC ADO auxiliary code. For a description of each, see the section Using Embedded EXEC ADO Statements in the chapter Using OpenESQL with ADO.NET.

Connected or Disconnected Models

• DECLARE DATASET
• DECLARE DATATABLE
• GET CHANGES
• INITIALIZE DATASET
• UNBIND DATASET

Disconnected Models

• ACCEPT CHANGES
• BIND DATASET
• BIND DATATABLE
• CLEAR
• DECLARE DATATABLE
• DECLARE UNTYPED DATASET
• GET DATATABLE
• INITIALIZE DATASET
• INITIALIZE DATATABLE
• LOAD DATASET
• MERGE DATASET
• REJECT CHANGES
• SAVE DATASET
• SAVE DATATABLE
• UNBIND DATASET
• UNBIND DATATABLE
• USING DATASET
• Generic SQL Program

  Generates a skeleton SQL program that includes the INCLUDE SQLCA statement and a default SQL error routine.

Connected Models

• BIND CONNECTION
• FILL DATASET
• GET CONNECTION
• PREPARE TO FILL
• PREPARE TO UPDATE
• REBIND CONNECTION
• UNBIND DATASET
• UPDATE DATASOURCE
• UNBIND CONNECTION
• TO DELETE USE
• TO FILL USE
• TO INSERT USE
• TO REFRESH USE
• TO UPDATE USE
• Generic SQL Program

  Generates a skeleton SQL program that includes the INCLUDE SQLCA, CONNECT and DISCONNECT SQL statements and a default SQL error routine.