RE: UPDATE of Type DEC with Error
Ralf.
DBMONEY has to be set in the runtime environment of your application. In
UNIX you would put it in the .profile, .bashrc or .bash_profile dependend of
your shell.
If your app. runs under windows you can set it with the setnet32 tool.
But it's strange that both decimal values with "," or "." fail.
Please try dbschema -d database -t table table_schema to verify the type of
the column in question.
Reinhard.
> -----Original Message-----
> From: informix-list-bounces@iiug.org
[mailto:informix-list-bounces@iiug.org] On
> Behalf Of Ralf Hackmann
> Sent: Thursday, January 28, 2010 11:24 AM
> To: informix-list@iiug.org
> Subject: Re: UPDATE of Type DEC with Error
>
>
> > Try
> >
> > UPDATE fyar2sta Set BEWPRS=73.62 Where Sa=0 and Artikel => > '00010381-0100 ';
> >
> I tried it befor with the same error.
>
> If I try
> UPDATE fyar2sta Set BEWPRS='73,62' Where Sa=0 and Artikel => '00010381-0100 ';
> it runs ( 1 row(s) updated )
>
> If I look in my applikation (ERP-Sytem) I can see 73,62 in the Field
> BEWPRS of the Artikle 00010381-0100
> Can I be shure that it is DEC(15,2) and not String.
>
> > different environments. Have a look on environment variable DBMONEY. I
>
> Where is DBMONEY set and where can I change it?
>
> Ralf
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list