Finally the undocumented feature: "Support for the DECIMAL CHARACTER to be COMMA and still use the comma for a DELIMITER."
cannot be used as the command UNLOAD gives wrong results: 1. DOUBLE data type columns with no decimal point 2. CURRENCY and DOUBLE with no quotes So back to B currency convention... It seems that this 'enhancement' was not tested enough to be documented. I wonder if it should have ever been included in enhancements list at all. Polychronis T. Kontos Athens, Greece > -----Original Message----- > From: ELOEN [mailto:eloen@;ath.forthnet.gr] > Sent: Thursday, November 07, 2002 12:51 PM > To: [EMAIL PROTECTED] > Subject: RE: Currency convention (A) should be independent of > delimiter char (,) > > > Dear Bill, > > > > > What version of R:Base are you using? > > I'm using 1.851xRT03 win > > > > > Before R:Base 6.5+, to get a european currency format to display, you > > would have had to change the delimit character, which would have > > caused problems in r:style and r:code. Oliver Reuter demonstrated and > > explained the problem to Wayne at the 2000 Developers Conference. > > A fix was included in the December, 2000 release of 6.5+ Below is > > from the file RBWIN65P.TXT, dated December 29, 2000: > > > > ============================================== > > November 14, 2000 > > R:BASE 2000 (ver 6.5) for Windows - Pre In-Line Patch-3 > > (1.837FxRT03) > > > > Enhancements > > 02. Support for the DECIMAL CHARACTER to be COMMA and still > > use the comma for a DELIMITER. (#1007) > > > > Note: You can only SET such setting at the mighty R> prompt or > > in a command/procedure file. > > > > ============================================== > > It's great to be true! My first tests shows: > > 1. No error message "Decimal character cannot be the same as > DELIMIT" after the command: > --Change currency, leaving delimit as comma(,) > SET CURRENCY 'E' SUFFIX 2 A *(English capital letter) > > 2. The following commands: > SET V vc1 CURR = 1234,56 > SET V vc2 CURR = '1234,56' > SHOW V vc% > > give: > vc1 = 123.456,00E CURRENCY > vc2 = 1,234.56E CURRENCY > > of which only the 2nd is correct. > > 3. Going on: > SET V vd DOUBLE = 2,02 > gives syntax error > SET V vd DOUBLE = '2,02' > works ok > > also: > SET V vc1 = (12,12 / 6) > SET V vc1 = (12,12E / 6) > SET V vc1 = ('12,12E' / 6,06) > SET V vd = (12,12 / 2,02) > give an error that "Expression contains an extra comma", while: > SET V vc1 = ('12,12E' / 6) > SET V vc1 = ('12,12E' / .vd) > SET V vd = ('12,12E' / '2,02E') > SET V vc1 = (.vc2 / .vd) > SET V vd = (.vc1 / .vc2) > work ok. > > But that could be a minor problem, if everything else is ok. > I'll give it a try with columns and functions as well. > > Thanks. > > Polychronis T. Kontos > Athens, Greece > > > ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
