Dan,
To the best of my knowledge the only way to accomplish this is to unload the
database, edit the unload file to change the line
SET CURRENCY '$' PREF 2 B to a different value, you may have to also change
RBENGINE??.CFG file, rename original .RB? or .RX?, reload database.
Here is appropriate info from RSYNTAX.com
"
CURRENCY
Operating Condition
Syntax: SET CURRENCY $ PREF 2 B
SET CURRENCY sets the symbol, location, subunits, and format for currency
values. R:BASE stores the setting with the database.
Changing the CURRENCY parameters affects all columns in the database
that have a CURRENCY data type. You must enter the parameters in the
following order: SYMBOL, PREF or SUFF, digits, and format; that is,
even if you want to change the digits only, you must also enter the
symbol and its position.
· Symbol (default $)--A symbol is any ASCII character or string of one to four
characters. You can include a space in place of one character at the
beginning or end of the string, but if you do, enclose the string in
quotation marks.
· PREF and SUFF (default PREF)--Specify the position of the symbol as before
(PREF) or
after (SUFF) the currency value. In the SET CURRENCY command, enter a
space between the symbol and its position, PREF or SUFF.
· Subunit digits (default 2)--Indicates the number of digits from 0 to 16 to be
displayed in a currency subunit. In the case of dollars, the subunit is
cents, so the digits setting for dollars is 2. For example, setting
digits to 3 will display currency values similar to these:
20.000,000DM
20,000.000
2,000.000
If
you change digits when the database contains data, the new digit
setting affects how R:BASE displays and uses the data already entered.
For example, if you change the setting from 2 to 4, an existing value
such as 1,234.00 becomes 12.3400.
· Format (default B)--Format specifies how R:BASE displays the thousands and
decimal delimiters. A, B, and C specify how the thousands and decimal delimiter
displays for values
with CURRENCY, REAL, and DOUBLE data types. Before you change the
format, you must change the DELIMIT character.
Delimiter Conventions for CURRENCY, REAL, and DOUBLE Values
Convention
Thousands Delimiter
Decimal Delimiter
Example
A
.
,
123.456.793,01
B
,
.
123,456,793.01
C
(blank)
,
123 456 793,01
D
N/A
.
123456793.01
For example, to display currency in two digits with a prefix of DM (deutsche
marks) with the display format A, at the R> prompt, enter:
SET DELIMIT=!
SET CURRENCY DM PREF 2 A
This command displays 1,500 deutsche marks and 25 pfennigs in the format like
this:
DM 1.500,25.
If you set CURRENCY to the delimiter formats A or C without changing DELIMIT
to a character other than the comma--the
default setting for DELIMIT--R:BASE displays the following message:
Decimal character cannot be the same as DELIMIT
In
this case, use SET DELIMIT to change the delimiter to a less commonly
used character such as an exclamation point; then set CURRENCY to the
delimiter formats A or C.
"
Jim Bentley
American Celiac Society
[email protected]
tel: 1-504-737-3293
________________________________
From: Dan Goldberg <[email protected]>
To: RBASE-L Mailing List <[email protected]>
Sent: Monday, June 1, 2009 9:59:37 AM
Subject: [RBASE-L] - changing currency subunit digits
I need to change the subunit digits from the normal two digits to four
digits.
The problem I have is when I change all my numbers shift over.
Example
10.99 is now .1099
How can I keep the decimal in the same place without having to multiple the
numbers in all the tables?
Dan Goldberg
