Description

The Using keyword causes the Run_Report to use a dictionary other than the dictionary of the table being listed or selected.

Syntax

List table Using alt_table

Remarks

Using follows the table name in the report command. It is followed by the name of the table whose dictionary is to be substituted. The Using keyword permits you to maintain one master dictionary for several tables. This is useful in situations where tables have identical layouts, such as master and history tables. The master table can have an associated dictionary, and the history table can simply refer to that dictionary when reports are generated - no separate dictionary is required for the history table. This minimizes both maintenance and storage requirements.

Example

* The dictionary of the table INVOICES is substituted for the
* dictionary of the table INVOICES_HISTORY.
 
stmt = "LIST INVOICES_HISTORY Using INVOICES"
Run_Report("",stmt)
  • No labels