This method is the most convenient one when you want to use the results obtained through using functions built into your DBMS. When the "use first result set's column as a list" option is switched off, independent of the obtained data set, the program will use only the first field of the first record in the results in the generation process. Please refer to fields group feature to use another columns of the result set.

There are settings for this fill method:

• When "Use result set as a list" is switched on the program uses result set of the statement execution. Otherwise, the program will execute entered statement for each value and use only first value of the first results column.
• "Use list items as a pattern" means each list value will be processed as a pattern before using.
• "Use values sequentially" option means the program will use list items from the first to the last. When the list ends the program starts from the first item again.