Viewing 6 posts - 1 through 6 (of 6 total)
You guys are the best!
I needed to do something similar and was stumped. So I cruised the Forum - found this example - and now am off to the...
November 23, 2002 at 8:57 pm
Interesting, but my options are limited. I cannot change the structure of the table and I do not want to change much of the web pages. The numbers...
November 4, 2002 at 7:31 am
You guys are good!
The datafield is specified by Pivotal as currency, but in sql the datafield is a Float length=8 precision=15. If I use sql to change it to...
November 3, 2002 at 9:11 pm
Hi,
I tried:
update tableA
set field1 = cast(field1 as decimal(38, 2))
where field1 is not null
and it did not work, the data is still stored 1.00000000001
To make a short story long, the reason...
November 1, 2002 at 4:34 pm
Thanks,
I asked my question incorrectly. What I would like to do is change the data in the database to only store 2 decimals (from 1.000000001 to 1.00). I...
November 1, 2002 at 10:52 am
THANKS EVERYONE!!!
It was nice to have different options to choose from and pick the one that worked best for my situation.
Bill
October 1, 2002 at 10:55 am
Viewing 6 posts - 1 through 6 (of 6 total)