Re: Check uniqueness of primary key
From: Luc Loodts <luc.loodts_at_alcatel.be>
Date: Fri, 07 Aug 1998 11:15:00 +0200
Message-ID: <35CAC593.3C4F68A0_at_alcatel.be>
Date: Fri, 07 Aug 1998 11:15:00 +0200
Message-ID: <35CAC593.3C4F68A0_at_alcatel.be>
Thanks for your help, but in the mean time, I solved the problem in another way:
I've created a temporary table in the database, in which I store the primary
key
fields while the operator is creating records (before the commit).
In the When-validate-item trigger, I scan this temp. table to see if the key
already exists. If so, I respond to the operator with a message, if not, I
store
the new key in the temp. table.
Greetings,
Luc Loodts.
Received on Fri Aug 07 1998 - 11:15:00 CEST