Re: Error 100
That's error -100. Status 100 (positive) means 'no rows found', and
that's probably what is happening.
Dragi "Bonzi" Raos
----- Original Message -----
From: "Andrew Hardy" <Andrew.Hardy@marconi.com>
To: <informix-list@iiug.org>
Sent: Friday, April 02, 2004 12:18 PM
Subject: Re: Error 100
>
> Execution of this:
>
>
> EXEC SQL SELECT constrname INTO :myConstraint FROM sysconstraints
> WHERE tabid = (SELECT tabid FROM systables
> WHERE tabname = :tab_name );
>
> Results in
>
> finderr 100
> -100 ISAM error: duplicate value for a record with unique key.
>
> A row that was to be inserted or updated has a key value that already
> exists in its index. For C-ISAM programs, a duplicate value was
> presented in the last call to iswrite, isrewrite, isrewcurr, or
> isaddindex. Review the program logic and the input data. For SQL
> products, a duplicate key value was used in the last INSERT or UPDATE.
>
> BUT I cannot see that I am updating.
>
> I carry this same statemetnt out immediately following the failure
using
> dbaccess and it is successful.
>
> Does any one know what other mewanings error 100 may have.
>
> Andrew H
>
>
> sending to informix-list
>
>
sending to informix-list