Re: Help: How to write a trigger to prevent from a primary-key violateing inserting

Two suggestions: 1. Trap the error message in your client's software (WHENEVER SQLERROR for Informix 4GL) 2. Why don't you let the system assign a primary-key. It appears, that users enter the primary key in your case. What do you do, if the user changes the primary key value? Update all the related records? E.g. we have an integer-column in all our tables and do a SELECT MAX. Others use a SERIAL-column. Just my thoughts, Roland Jonathan Tsai wrote: > > Hi there: > > As title. The reason that I want to do that is because of trying to get rid > of error message returning to the end-users. > > Jonathan Tsai > Jonathan@autumn.ccl.itri.org.tw