Re: Help? Check for dups before insert in Forms4.5
From: Sunil Godithi <sunil_at_ameya.com>
Date: 1996/10/01
Message-ID: <3250BBC3.D64_at_ameya.com>#1/1
Date: 1996/10/01
Message-ID: <3250BBC3.D64_at_ameya.com>#1/1
Only way I could figure out was using record groups and it definetly is
not easy (in the beginning).
Sunil
bartavi_at_mail.tlm.openu.ac.il wrote:
>
> 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 Tue Oct 01 1996 - 00:00:00 CEST