Micro Focus Enterprise Developer 3.0 for Visual Studio 2017 > Programming > Data Access > Database Access > Reference > OpenESQL > Embedded ADO Statements > PREPARE TO FILL

PREPARE TO FILL

Begins the process of loading the DataTables in a DataSet from a data source.

Syntax:

                                                    +--   ,    --+
                                                    V            | 
>>--EXEC ADO-.--------------------.-PREPARE TO FILL-datatable_name-->
             +-USING dataset_name-+  
 >--END-EXEC---><

Parameters:

`datatable_name`	The DataTables that are prepared to be filled by the data source.
`dataset_name`	The DataSet reference to be used. If you do not specify dataset_name, the current DataSet is used.

Comments:

After using PREPARE TO FILL to specify the DataTables that are to be loaded by the data source, use the TO FILL statement to specify how to retrieve the data from the data source. The FILL statement completes the process.

Example:

     EXEC ADO
        PREPARE TO FILL Customers, Orders, "Order Details"
     END-EXEC