Re: Trigger checking for Dupes
From: Daniel Poweleit <powi_at_horn-goerwitz.de>
Date: 1997/09/19
Message-ID: <01bcc4c7$6a4257c0$8c8765c1_at_dpoweleit.horn-goerwitz.de>#1/1
Date: 1997/09/19
Message-ID: <01bcc4c7$6a4257c0$8c8765c1_at_dpoweleit.horn-goerwitz.de>#1/1
Try the WHEN-VALIDATE-ITEM-Trigger on LAST-NAME. With a little select you
are able to check if the user exists
before inserting the record.
David Turner <turner_at_vortex.more.net> schrieb im Beitrag
<5vrht6$srs$1_at_news.more.net>...
> Does anyone have code for a preinsert trigger that will check
> if a user with the same first_name and last_name exists and if
> so return the user to a clear block. I am having problems clearing
> the block when I try to do this.
>
> Thanks, DaveT
>
>
Received on Fri Sep 19 1997 - 00:00:00 CEST