Re: Help? Check for dups before insert in Forms4.5
From: <bartavi_at_mail.tlm.openu.ac.il>
Date: 1996/09/26
Message-ID: <DyD18p.J66_at_cs.openu.ac.il>#1/1
Date: 1996/09/26
Message-ID: <DyD18p.J66_at_cs.openu.ac.il>#1/1
janssenj_at_ix.netcom.com wrote:
>Does anyone know an easy way to check for duplicates in a multi-record
>block in Forms before committing the rows to the database?
>Thanks in advance.
you can write triggers that runs on all the rows, when you insert a
new record, and compares them to the current row
OR
you can create unique key on the table and handle the exception that
raises when it's voilated.
OR you can use the two methods together...
good luck,
Bartal V. Received on Thu Sep 26 1996 - 00:00:00 CEST