Forum Replies Created

Viewing 6 posts - 1 through 6 (of 6 total)

  • RE: Can a Trigger Update another database?

    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...

  • RE: Format data

    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...

  • RE: Format data

    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...

  • RE: Format data

    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...

  • RE: Format data

    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...

  • RE: Comparing fields that have null values.

    THANKS EVERYONE!!!

    It was nice to have different options to choose from and pick the one that worked best for my situation.

    Bill

Viewing 6 posts - 1 through 6 (of 6 total)