TO FILL USE

Specifies, for a specific DataTable, the SQL logic necessary to load the columns of that DataTable with data from a data source.

Syntax:

>>--EXEC ADO--.--------------------.--TO FILL  datatable_name-->
              +-USING dataset_name-+

 >---.-------------------------------------------------.------->
     |                                                 |
     |           +---------------  ,  --------------+  |
     |           V                                  |  |
     +- MAPPING--datatable_col_name AS table_col_name--+                        
  
 >--------------USE--+-sql_select_statement----------+--------->
                     +-stored_procedure_statement----+                          
                          
 >--END-EXEC---><

Parameters:

datatable_name The name of a DataTable.
dataset_name The DataSet reference to be used. If you do not specify dataset_name, the current DataSet is used.
datatable_col_name The name of a column in a DataTable.
table_col_name The name of a column in a table in a data source.
sql_select_statement A standard SQL SELECT statement that references a table in a data source.
stored_procedure_statement Specifies the stored procedure to execute.

Comment:

The SQL logic must reference actual tables and columns in the data source.

Example:

     EXEC ADO
        TO FILL Customers USE
        SELECT CustomerID,CompanyName,ContactName,ContactTitle,Address          
        ,City,Region,PostalCode,Country,Phone,Fax 
        FROM Customers WHERE CustomerID LIKE :pattern
     END-EXEC