RE: Referential integrity issues

I hadn't seen any posts, so figured I would post something. Albeit, probably not to useful, but something. I have never seen an INSERT fail and return success in SQLCODE. Then again, there are lots of things I have never seen. I have seen SQLCODE not checked soon enough, as well as code not going down the 'expected path' many times. I would be real interested if this turns out to be a bug in informix though. Will >===== Original Message From "Carlson@WHSmith" <carlson1@bellsouth.net> ===== >I4GL 7.20.ud6 >IDS 7.30.uc7 >HPUX 10.20 > >I've been told of a real weird problem within a piece of our 4GL code. > >We have some home-grown code that starts a transaction, inserts a master >record, checks the return code, then inserts multiple detail records, >checks the return code and commits the transaction. Any problem with >the inserts will cause the error routine to pop a window, warn the user, >and rollback the transaction. Referential integrity is active between >the tables. Most of the time, the code acts normally and all is well. > >Every now and then, we'll get the dreaded -691/-111 errors. Apparently, >the master insert doesn't happen, but SQLCODE doesn't show that fact. >(We have checked the master table while the error is on the screen; no >master record.) > >Any ideas? This is causing a few gray hairs, and I don't have many left >to spare . . . . 8-) > >-- >John Carlson >Informix DBA >WHSmith USA > >#include std_disclaimer.h /* These are my opinions, not my company's >opinion */ ------------------------------------------------------------ This e-mail has been sent to you courtesy of OperaMail, as a free service from Opera Software, makers of the award-winning Web Browser, Opera. Visit us at http://www.opera.com/ or our portal at: http://www.myopera.com/ Your free e-mail account is waiting at: http://www.operamail.com/ ------------------------------------------------------------