I remember reading something about a guy (long time ago) working for a bank
and had the rounding errors at like the 8 decimal position deposited into 
his account.
Ended up accumulating a lot of money. Course I think he may have gone to 
jail.
 


-----Original Message-----
From: "Dan Goldberg" <[email protected]>
To: [email protected] (RBASE-L Mailing List)
Date: Mon, 1 Jun 2009 12:46:46 -0700
Subject: [RBASE-L] - Re: changing currency subunit digits


I am going to have to do formatting on form and reports. This is due to the 
sales people only want to see two digits and the accounting/purchasing want 
to see four digits. 
 
I guess that ten thousandth of a dollar is important...
 
Dan Goldberg




From: [email protected] [mailto:[email protected]] On Behalf Of Bill Downall
Sent: Monday, June 01, 2009 11:15 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: changing currency subunit digits


Dan, 


For reasons James describes, especially the "global" setting -- where what 
you do for CURRENCY anywhere affects what you get for CURRENCY everywhere -- 
 I have used DOUBLE  or NUMERIC for storing money for a long time, using 
formatting features of forms and reports to add dollar signs where 
appropriate. The biggest problem with DOUBLE was accurately storing very 
large values, like the national budget. And now in 8.0 and later, the BIGNUM 
data type takes care of that very nicely.


Bill


On Mon, Jun 1, 2009 at 1:42 PM, James Bentley <[email protected]> 
wrote:

Dan,

Currency is one area in RBase that poses a challenge for International 
users.  Currency is a global setting for the database. In multi-currency 
reporting you usually have multiple currency types: base currency, 
functional currency, reporting currency, etc. 
Thus in a multi-currency accounting system for a given Account you may have 
three or more currencies, with different digit and subdigit requirements 
along with comman and period display differences. 

Thus while you would not have euro's, or yen, or dollars in the same column 
you might need to have them all present in the same database. To the best of 
my knowledge the SQL standards do not address currency in any manner similar 
to the way NATIONAL CHARACTER data could be defined.

Any international users feel free to chip in on how you handle this problem. 



 
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 12:05:07 PM
Subject: [RBASE-L] - Re: changing currency subunit digits


Thanks. I knew it had something to do with unloading/loading the database.
 
Dan Goldberg




From: [email protected] [mailto:[email protected]] On Behalf Of James 
Bentley
Sent: Monday, June 01, 2009 8:45 AM 

To: RBASE-L Mailing List

Subject: [RBASE-L] - Re: changing currency subunit digits


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

Reply via email to