Hi,
No I am not doing anything to the PK.
I traced the error to a trigger which fires on update doing an insert on an
other table and this -239 was for that table.
Thanks
Sathish Sadagopan
-----Original Message-----
From: ackerbau@us.ibm.com [mailto:ackerbau@us.ibm.com]
Sent: Thursday, January 14, 1999 1:36 PM
To: informix-list@iiug.org
Subject: Re: -239/100 error on update-Urgent
Are you updating the primary key to a non-unique value?
-mka
Michael Ackerbauer
SP System Test
===
"Sadagopan, Sathish, CFCTR" <sadagop0458@att.com> on 01/14/99 10:57:53 AM
To: informix-list@iiug.org
cc: (bcc: Michael K Ackerbauer/Poughkeepsie/IBM)
Subject: -239/100 error on update-Urgent
Hi,
I am getting a -239 error , isam err 100 when a program is trying to do an
UPDATE on a table with unique constraints.
What could the problem be ?
TIA
Sathish Sadagopan