Re: commas in money field

Dirk Schmidtpott wrote: > > Mark D Stock wrote: > > [SNIP] > > I believe it's called DBFORMAT, but I don't have my manual handy. It allows the setting > > of prefix and suffix chars, as well as the decimal and thousands chars. > > Sorry Mark, but I have checked all environment variables described in my > manuals, which I have right in front of me ;-), and I did not find a DBFORMAT > or at least something similar, that does the things you have described above. > Meanwhile, back at the office. I have dusted off a copy of 'INFORMIX Guide to SQL Reference' which is a December 1991 edition. On page 4-9 it describes DBFORMAT (so I was right :), which is set to 'front:thousands:decimal:back'. It is used to format DECIMAL, MONEY, FLOAT, SMALLFLOAT, INTEGER & SMALLINT. Both front & back are 1-7 chars for the currency. Both thousands & decimal are one or more (bit vague) characters used to separate the thousand and decimals respectivly. Strangely enough, on the next page it describes DBMONEY format as '[front][.|,][back]'. Again both front & back are 1-7 chars each. Hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+