To populate a dynamic table field from a database table, use an SQLSelect object or a QueryObject object and point the target array of the query object to the array you declared for the table field.

For example, the DynamicQuery frame uses a query object to load a dynamically created table field at runtime. The code in this frame that retrieves the data from the database and displays it in a table field performs the following operations:

The following code performs these operations:

Opening a query object in QY_ARRAY mode retrieves all the data directly from the database into the named array during the Open method invocation. (The Load and NextRow methods are not required to display the data on the form.) Because array mode eliminates intermediate steps in retrieving and displaying data, performance is better using array mode rather than cache, cursor, or direct modes.

For array mode, the class of the array being loaded must have attribute names matching the names of the columns in the query (the array attributes must match all columns whose IsSelectTarget attribute has been set to TRUE).

For more information about using SQLSelect and QueryObject objects, see Creating Dynamic Frames.