Re: Unique Indexes

}Date: Wed, 19 May 93 09:02:52 -0400 }From: David Nguyen <uunet!ge!davidn%davidn> }Subject: Unique Indexes }X-Informix-List-Id: <list.2295> }I have a table in which there's a unique index created, and it involves 9 }columns. I'm having a problem when I goto $select from it in one of my }*.ec files. The sqlca.sqlcode returned is 100 (SQLNOTFOUND). }When I looked it up in the ESQL manual, the ISAM error reads: }"there is already a record with the same value in a unique key." }and the Corrective Action specified: }"Check that you did not attempt to add a duplicate value to a column with }a unique index by way of iswrite, isrewrite, isrewcurr, or isaddindex." Error number -100 means duplicate value for a record with a unique key, and all the other stuff you said, but you didn't get error -100, you got return code +100 (SQLNOTFOUND), which means that there are no (more) rows to be returned. It is the normal end of cursor indication. Yours, Jonathan Leffler (johnl@obelix.informix.com) #include <disclaimer.h>