Thank´s a lot Razzak, .. I tried at the R>prompt as test ... R> SET VAR v1 INTEGER = 2137903 R> v1 = 2137903 INTEGER and I wanted: R> v2= 2.137.903 INTEGER, to be achieved with SET VAR v2 INTEGER = (FORMAT(.v1,"whatever-has-to-be-here")) But it looks I have to live with a "2.137.903" TEXT result and then to "FLOAT" along. Best regards to the US ! Fritz, Germany, Bavaria - Danke ! Das hilft immer !
-----Ursprüngliche Nachricht----- Von: [email protected] [mailto:[email protected]] Im Auftrag von A. Razzak Memon Gesendet: Montag, 24. Juni 2013 19:44 An: RBASE-L Mailing List Betreff: [RBASE-L] - Re: FORMAT At 01:22 PM 6/24/2013, Dr. Fritz Luettgens wrote: >R:BASE eXtreme 9.5 (64), Build: 9.5.3.20611, Win7 Ultimate > >R> SET VAR v1 INTEGER = 2137903 >R> set var v2 INTEGER = (FORMAT(.v1,"#0.0;_#0.0")) >-ERROR- Your value does not have the same type or scale as your >variable v2 (2178) > >Can´t find my mistake anymore, serious beginner blues, thank´s Fritz > >Conf Settings: >Quotes >Delimit , >Tolerance 0, >(Europe) Dr. Fritz Luettgens, You are using the Display Format Mask supported in Forms and Reports. However, for R:BASE FORMAT used at the R> prompt or in a command file, please refer to HELP FORMAT. -- Example SET VAR v1 INTEGER = 2137903 SET VAR v2 = (TRIM(FORMAT(.v1,'00000000.0'))) Hoffe, das hilft! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
