Ahhh... a currency setting! Yes of course, that makes sense! Karen
-----Original Message----- From: Stephen Markson <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Jan 21, 2015 2:57 pm Subject: [RBASE-L] - Re: Forms: Enhanced db Grid: column Integer Karen, I believe Fritz wants to display integers using the usual European notation i.e. the thousands separator is the period. Ex: “one thousand” is shown as 1.000 Fritz, your solution will depend on your CURRENCY setting. You may need to change the setting before and after using the forms. Here is a potential solution to your problem. I am assuming that your currency setting uses convention “A” as in: SET CURRENCY ‘DM‘ SUFF 2 A Create a single-table view that has all of the columns that you need in your DB grid and use a FORMAT for your integer column. For example: CREATE TEMPORARY VIEW TempV (col1,col2,…,IntegerColumn,nextcolumn,…) AS + SELECT col1,col2,…,(FORMAT(IntegerColumn,’999.999’)),nextcolumn,… FROM YourTable It works for me! Regards, Stephen Markson The Pharmacy Examining Board of Canada 416.979.2431 x251 From: [email protected] [mailto:[email protected]]On Behalf Of Karen Tellef Sent: January-21-15 11:59 To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Forms: Enhanced db Grid: column Integer I understand that! I had a thought, for the computed column you could also define a Numeric datatype and specify 3 as the decimals. That would be the easiest. Of course a computed column would not be editable. Karen -----Original Message----- From: Dr. Fritz Luettgens <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Jan 21, 2015 10:53 am Subject: [RBASE-L] - AW: [RBASE-L] - Re: Forms: Enhanced db Grid: column Integer Thank you Albert and Karen ! Dear Karen, a computed column is a possibility, but I would have to add loads of computed columns just to get the effect. Fritz Von:[email protected] [mailto:[email protected]]Im Auftrag von Karen Tellef Gesendet: Mittwoch, 21. Januar 2015 17:36 An: RBASE-L Mailing List Betreff: [RBASE-L] - Re: Forms: Enhanced db Grid: column Integer Maybe you could add a computed column, using the "format" function? Karen -----Original Message----- From: Albert Berry <[email protected]> To: RBASE-L Mailing List <[email protected]> Sent: Wed, Jan 21, 2015 10:10 am Subject: [RBASE-L] - Re: Forms: Enhanced db Grid: column Integer I don't see an option to do this either. I looked in RDOCS and there is nothing in there for an enhanced db grid column format. Albert On 1/20/2015 5:33 PM, Dr. Fritz Luettgens wrote: > Hi, > Situation: > I have columns Integer in a table which I use with a Form within an Enhanced > DB Grid, i.e. say the column "Quantities". > Well, looks like: 123123 > but I would like to display the Integer Values like 123.123 (a > formatted > version) > Is there a direct way without using variables (with temp Views, temp Tables > a.s.o) or is there a Property command to format > a column within an enhanced db grid ? > How do you achieve this ? > Thank´s > Fritz >
