Connected Model Statements

Connected model statements enable you to interact with a data source. The FILL commands retrieve data from a data source and place it into the DataTables of a DataSet. The UPDATE commands ensure that any Data Manipulation Language (DML) changes (INSERT, UPDATE, and DELETE) are returned to the data source.

The following connected model statements are available to you:

• PREPARE TO FILL – signals the DataSet to be filled
• TO FILL USE – specifies the logic to retrieve data from table in data source to DataTable in DataSet
• FILL – does the actual fill of the DataTables
• PREPARE TO UPDATE – signals the DataSet whose DML changes are to be placed in a data source
• TO DELETE USE – specifies the delete logic to be used in a data source
• TO INSERT USE – specifies the insert logic to be used in a data source
• TO REFRESH USE – specifies the refresh logic to be used in a data source
• TO UPDATE USE – specified the update logic to be used in a data source
• UPDATE – does the actual update to a data source