(FORMAT(.vReal,'[-]999,990.00')) The [-] part tells it to put the negative sign on the right so there will be no space on the left.
Dennis ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Thursday, May 14, 2009 10:28 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Fetch cursor Group, I rarely use format masks hence the question. I have a Variable Edit REAL that I want to show as a CURRENCY. How is the format mask entered? Jan -----Original Message----- From: Lawrence Lustig <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Thu, 14 May 2009 08:09:46 -0700 (PDT) Subject: [RBASE-L] - Re: Fetch cursor << During trace I watch the variable vEdiFile and it displays a space as the first character after fetched. I can use the "Modify variable value" tool and confirm that the variable has a space as the first character. I have double and tripled checked that the data in the table does not have a space in front of it. >> If you're 100 % certain the problem is not in the data, can you post the DECLARE CURSOR for c100? It sounds like you may be using an expression of the form (Col1 & ' ' & Col2) where you think you're referring only to Col2. -- Larry
