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

Andrew Hardy wrote: > > 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.