Micro Focus Visual COBOL 2.3 for Visual Studio 2015 > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded ADO Statements > UPDATE

UPDATE

Updates a data source with changes made in the DataTables of a DataSet.

Syntax:

>>--EXEC ADO----—UPDATE DATASOURCE-----END-EXEC--><

Comment:

This statement can only be executed after a PREPARE TO UPDATE statement and subsequent TO INSERT, TO UPDATE and TO DELETE statements. The TO commands specify the SQL logic necessary to change tables in the actual data source. If no TO commands are created, OpenESQL attempts to supply default SQL. For a table with no parent tables the default SQL is to select all rows in the table. For a table with a parent table the default SQL is to select rows for which the parent rows have been selected.

Example:

     EXEC ADO
        UPDATE DATASOURCE
     END-EXEC