Error Updating Integer Field
Flip van Wyngaardt got error 1213 (character to numeric conversion failed) only on UPDATE of an integer column in Informix 11.7FC8; select, insert and delete worked. Andreas Legner suspected a bug or corruption, suggested testing a copy of the table, or trapping the error with onmode -I -1213 for a PMR. Fernando Nunes asked about an update trigger. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
informix11.7FC8:
Table
create table internal_attorney
(
userid varchar(20) not null ,
locationid integer not null ,
isactive char(1) not null ,
allocated_files integer,
primary key (userid) constraint "informix".primary
);
SQL
Update internal_attorney set allocated_files = 2 where userid ='user'
when trying to update allocated_files we get the following error:
# 1213: A character to numeric conversion process failed
any help will be appreciated.
A problem probably at retrieving and interpreting the row (or one of the=20
rows addressed). Would you see the same for a SELECT using same WHERE=20
clause?
From: "FLIP VAN WYNGAARDT" <flipv@raf.co.za>
To: ids@iiug.org
Date: 01.07.2016 12:03
Subject: Error Updating Integer Field [37345]
Sent by: ids-bounces@iiug.org
informix11.7FC8:=20
Table=20
create table internal=5Fattorney=20
(=20
userid varchar(20) not null ,=20
locationid integer not null ,=20
isactive char(1) not null ,=20
allocated=5Ffiles integer,=20
primary key (userid) constraint "informix".primary=20
);=20
SQL=20
Update internal=5Fattorney set allocated=5Ffiles =3D 2 where userid =3D'use=
r'=20
when trying to update allocated=5Ffiles we get the following error:=20
# 1213: A character to numeric conversion process failed=20
any help will be appreciated.=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
When selecting,deleting and inserting it works fine only update return this error. Is this maybe a bug?
Interesting. Root cause might be a bug, or some sort of corruption whose=20
root cause might again be one ;-)
I'm assuming the same is working if you try it on an SQL copy of the table =
(same schema, insert into ... select from ...)?
Maybe this would then suffice even to solve your immediate problem.
Else I'd try tapping the error (onmode -I -1213 -> create the error ->=20
disable the trap using 'onmode -I') and providing the resulting af file in =
a new PMR. This might give a better clue where exactly sich 'character to =
numeric conversion' occurs, and on which data.
Andreas
From: "FLIP VAN WYNGAARDT" <flipv@raf.co.za>
To: ids@iiug.org
Date: 01.07.2016 12:25
Subject: Re: Error Updating Integer Field [37347]
Sent by: ids-bounces@iiug.org
When selecting,deleting and inserting it works fine only update return=20
this=20
error.=20
Is this maybe a bug?=20
***************************************************************************=
****=20
Forum Note: Use "Reply" to post a response in the discussion forum.=20
Do you happen to have an UPDATE trigger on it? ;) On Fri, Jul 1, 2016 at 11:24 AM, FLIP VAN WYNGAARDT <flipv@raf.co.za> wrote: > When selecting,deleting and inserting it works fine only update return this > error. > > Is this maybe a bug? > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --94eb2c05665c2d3f81053690cd12