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>


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

Original text of this message