Previous Topic Next topic Print topic


FILL

Adds new DataRows to (or refreshes the existing DataRows of) the DataTables in a DataSet using data from the data source.

Syntax:

>>--EXEC ADO--FILL--DATASET--.--------------.-->
                             +-dataset_name-+
>--END-EXEC--><

Parameters:

dataset_name The DataSet reference to be used. If you do not specify dataset_name, the current DataSet is used.

Comments:

This statement can only be executed after a PREPARE TO FILL and subsequent TO FILL statements. The TO FILL statements specify the SQL logic necessary to fill different DataTables from a data source.

If no TO FILL statements are used, OpenESQL attempts to supply default SQL. For a table with no parent tables the default SQL will select all rows in the table. For a table with a parent table, the default SQL selects the rows for which the parent rows have been selected. Tables are filled in the correct order to satisfy relationships between tables, for example, parent before children. The generation of default SQL searchs all relationships between tables, allowing a FILL statement for a parent table to be used to generate queries for children, grandchildren, great grandchildren and so on.

Example:

     EXEC ADO
        FILL DATASET
     END-EXEC
Previous Topic Next topic Print topic