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 
         <javascript:parent.reDisplay('1',2,0)> Top
<javascript:parent.reDisplay('2.19.8.18',2,0)> Previous
<javascript:parent.reDisplay('2.19.8.20',2,0)> Next     

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