Problem is located in currency setting not delimiter. If currency is set to 2 A, you are not able to use the (6,1) as part of the alter command for numeric.
Bug is reported as #76386. Workaround till fixed: SET CURRENCY $ PREF 2 B ALTER TABLE testtable ADD COLUMN bbbc NUMERIC (6,1) SET CURRENCY € SUFF 2 A Enjoy Adrian > -----Ursprüngliche Nachricht----- > Von: [email protected] [mailto:[email protected]] Im Auftrag von Albert > Berry > Gesendet: Donnerstag, 10. Juli 2014 00:53 > An: RBASE-L Mailing List > Betreff: [RBASE-L] - Re: AW: [RBASE-L] - Re: NUMERIC (6,1) > > Next suggestion, Fritz: change the delimiter to period, and if it then > works, contact RDCC. > Albert > > On 09/07/2014 4:46 PM, Dr. Fritz Luettgens wrote: > > Thank´Albert, > > decimal does not help. > > As a beginner I thought there must be a mistake in my syntax somewhere, > > that´s why I asked the professionals first :) > > Fritz > > > > -----Ursprüngliche Nachricht----- > > Von: [email protected] [mailto:[email protected]] Im Auftrag von > Albert > > Berry > > Gesendet: Donnerstag, 10. Juli 2014 00:33 > > An: RBASE-L Mailing List > > Betreff: [RBASE-L] - Re: NUMERIC (6,1) > > > > Fritz, try with a decimal instead of comma. If that works, send a note to > > RDCC about this. They are very responsive to any of us with a documented > > error, or even a confusion. > > > > Albert > > > > On 09/07/2014 2:05 PM, Dr. Fritz Luettgens wrote: > >> R:BASE 95_64 > >> > >> delimiter is et "," > >> > >> Hi, > >> > >> SET VAR v1 NUMERIC (6,1) = 1000 -------------------------- is no > >> problem, but > >> > >> R>ALTER TABLE testtable ADD COLUMN testcol1 NUMERIC (6,1) > >> -ERROR- NUMERIC precision must be a number between 1 and 15. (2447) > >> > >> Where is my error ? :) > >> > >> Thank´s > >> Fritz
