Re: Programming Problem [message #18424] |
Wed, 30 January 2002 13:17 |
Norman Murray
Messages: 1 Registered: January 2002
|
Junior Member |
|
|
If you want to maintain the amounts stored on the database in US$, create an interface for the stored values by creating a packaged function that converts the stored values to the desired currency. Coding PRAGMA RESTRICT_REFERENCES ( {Your-function-name}, WNDS, WNPS, RNDS, RNPS) in the package specification file will enable use of the function in SQL select lists, enabling its use in a formula item, etc., where you can obtain the amounts by coding something like,
SELECT {Your-function-name}( {Amt-col-name}, 'R')
INTO :Amt_R
FROM {Your-table-name}
WHERE ...
I hope this helps.
Good luck!
|
|
|