Dan
  After changing your currency setting 

  SET CURR $ PREF 4 B

 UPDATE tableName  SET columnName = ((columnName + 0000) * 100)

Buddy


-----Original Message-----
From: [email protected] [mailto:[email protected]] On Behalf Of Dan
Goldberg
Sent: Monday, June 01, 2009 11:00 AM
To: RBASE-L Mailing List
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

--- RBASE-L
================================================
TO POST A MESSAGE TO ALL MEMBERS:
Send a plain text email to [email protected]

(Don't use any of these words as your Subject:
INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH,
REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP)
================================================
TO SEE MESSAGE POSTING GUIDELINES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: INTRO
================================================
TO UNSUBSCRIBE: 
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: UNSUBSCRIBE
================================================
TO SEARCH ARCHIVES:
Send a plain text email to [email protected]
In the message SUBJECT, put just one word: SEARCH-n
(where n is the number of days). In the message body, 
place any 
text to search for.
================================================


Reply via email to