Click to See Complete Forum and Search --> : Money!!


Nicolas
08-17-2000, 08:15 AM
Hi!
I have a field with money datatype, but!! It can't received a value like
"41331237"!!!
I can't understand why not!!!
Who knows why?

Thank you!

Nicolás

Lia
08-17-2000, 09:28 AM
Try using the CONVERT function in your sql string.
Something like "INSERT into myTable (field1,moneyfield)
VALUES('testvalue', CONVERT(money, '41331237')"


Lia



"Nicolas" <nsaf@hotmail.com> wrote:
>
>Hi!
>I have a field with money datatype, but!! It can't received a value like
>"41331237"!!!
>I can't understand why not!!!
>Who knows why?
>
>Thank you!
>
>Nicolás
>