<No Subject Supplied>

>From naomi Wed May 19 8:25:36 MST 1993 remote from qip From: naomi@qip (Naomi Walker) Message-Id: <9305191525.AA07320@qip> Received: from qip by misty.anasazi.com; Wed, 19 May 93 08:25:37 MST Received: by qip (5.61/1.2) (from naomi (Naomi Walker) to informix-list@rmy.emory.edu) id AA07320; Wed, 19 May 93 08:25:36 -0700 Subject: SQLNOTFOUND To: informix-list@rmy.emory.edu (Informix List) Date: Wed, 19 May 93 8:25:36 MST X-Mailer: ELM [version 2.3 PL11] Content-Type: text Content-Length: 911 > 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). SQLNOTFOUND is a positive 100, and is exactly as it sounds. The record didn't exist. I'd check your host vars one more time. > 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." This, I believe, is error -100. -- Naomi Walker (aka N7FSA) naomi@anasazi.com Phoenix, Arizona To get the full value of joy, you must have someone to divide it with. ---Mark Twain