FW: Duplicate serial in Informix 7.2.3

-----Original Message----- From: Clifford Burton Sent: Thursday, 26 July 2007 11:09 To: 'Art S. Kagel' Subject: RE: Duplicate serial in Informix 7.2.3 >On Jul 25, 4:19 pm, Roy Mercer <roy.mer...@gmail.com> wrote: >I think Roy has nailed it. I did not consider that the table may have >been created without a UNIQUE index or constraint. If it was a so >created, then a user using another poorly written application that >does "select max(serial_field) from ...; insert ... >(selected_value, ...)" or an interactive tool like dbaccess or isql >COULD manually insert a row with the same value that a properly >written app was inserting using the "0" value properly. Also, I'd be interested to know how you are determining the value of the serial column; if you are not reading the SQLCA record but reading for the maximum (as noted by Art above) you could indeed be causing the problem; rather than some-other user. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list ******************************************************************* Everything about this email and its attachments, including potentially confidential components, is only for the eyes and ears of the persons to whom it has been addressed (i.e. the persons whose names appear in the "To" section of the email; however, those listed in sections "CC" and "BCC" may also consider themselves included in the group whose eyes and ears this email is for.). In the event that no physical, emotional or spiritual resemblance can be made between you and the intended recipients, you have been mistakenly or deliberately omitted from the email, someone has given it to you, or you have nicked it. If you're not supposed to have access to this email, please delete it, destroy it and deprive others from it. Oh, and let us know when you are done. *******************************************************************