CurrencyTableUpdate
CurrencyTableUpdate verb
updates an existing currency table in the model.
The user interface equivalent is to modify the properties on the Currency Table property sheet.
If
you specify the option CurrencyTableType, the object
name of the currency table is optional.
For more information about updating Currency Tables, see CurrencyTableMake.
The syntax is as follows:
CurrencyTableUpdate [objCurrencyTable] [currencyopts] Associations assocopts| Argument |
Description |
|---|---|
| CurrencyTableUpdate objCurrencyTable |
Updates the currency table objCurrencyTable. objCurrencyTable can be the object name, object identifier, or both. |
| currencytableopts |
Optional parameters that specify columns in an external data source. For the complete list of options, see currencytableopts. If the currency exists, previously set options are retained unless you change them with this command. |
| Associations assocopts |
Optional parameters that specify associations for the currency table. For the complete list of options, see assocopts. |
Example
This example modifies the currency table by changing its data source, which requires specifying different columns.
CurrencyTableMake 869 "Currency Base Table" CurrencyTableType BaseTable
Associations 1315 "Country Code" AssociationType Type_Query
AssociationRole Role_CountryCode AssociationReferenced "Country Code"
Associations 1317 "Date" AssociationType Type_Query
AssociationRole Role_Date AssociationReferenced "Date"
Associations 1319 "Currency" AssociationType Type_Query
AssociationRole Role_Label AssociationReferenced "Currency"
Associations 1321 "Conversion Rate" AssociationType Type_Query
AssociationRole Role_Rate AssociationReferenced "Conversion Rate"