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
