RE: UPDATE of Type DEC with Error
Hi,
don't see any difference between the statements. But I guess you have
different environments. Have a look on environment variable DBMONEY. I
assume in the first case it is not set ore set to ".". In the second case it
is set to ",".
HTH
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 8:51 AM
> To: informix-list@iiug.org
> Subject: UPDATE of Type DEC with Error
>
> Hello,
>
> if I start the following SQL script with dbaccess I get an error
> message.
>
> UPDATE fyar2sta Set BEWPRS=73,62 Where Sa=0 and Artikel => '00010381-0100 ';
>
> 201: A syntax error has occured.
> Error in line 1> Near character position 31
>
> BUT
>
> UPDATE fyar2sta Set BEWPRS=73,62 Where Sa=0 and Artikel => '00010381-0100 ';
>
> 1 row(s) updated
>
>
> fyar2sta.ddl
> .....
> FIELD AR2_BEWPRS DEC(15,2) CISAM=DEC(15,2) COBOL=COMP3(15,2)
> # Bewertungspreis
> ....
>
> what ist the reason for that?
>
> Greetings
>
> Ralf
>
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
> don't see any difference between the statements. But I guess you have
> different environments. Have a look on environment variable DBMONEY. I
SORRY there was a mistake in my posting.
The seccont statement (without error) must be
BUT
UPDATE fyar2sta Set BEWPRS=73 Where Sa=0 and Artikel ='00010381-0100 ';
1 row(s) updated
( the different is BEWPRS=73 in statement without error an
BEWPRS=73,63 with error)
I didnt changed any environment variable between the statements.
Greetings
Ralf