Re: Forms4.5 Duplicate Recs in block

From: Greg Hoppan <alpha_at_mail.datanet.hu>
Date: 1997/11/17
Message-ID: <34708A5D.49D778C2_at_mail.datanet.hu>#1/1

Tracey Berukoff wrote:

> Can I catch a duplicate entry in a block if multiple records are
> entered
> without a commit? My block is multi-row and I don't want the user to
> have to commit each record before entering another. Values are
> populated
> via an LOV.
>
> ie: value A
> value B
> value A <==== ERROR, DUPLICATE VALUE
>
> Thanks in Advance!
> Tracey

Tracey Berukoff wrote:

> Can I catch a duplicate entry in a block if multiple records are
> entered
> without a commit? My block is multi-row and I don't want the user to
> have to commit each record before entering another. Values are
> populated
> via an LOV.
>
> ie: value A
> value B
> value A <==== ERROR, DUPLICATE VALUE
>
> Thanks in Advance!
> Tracey

Tracey,

My favourite solution is:

Instead of committing after each row, try posting. Posting is enough to send the data to tha database, without a commit. After posting each record, you can check your actual record record against the database in the when-validate-record trigger.

Hope this helps

G

---

Hoppan Greg Gergely                  WWW  : http://w3.datanet.hu/~alpha/

Managing Director                    Mail : alpha_at_mail.datanet.hu
Alpha Consulting 1996 Limited        Phone: +36-1-351-9020

HUNGARY 1068 Budapest, Benczur u 14 Fax : +36-1-351-9020

---

Received on Mon Nov 17 1997 - 00:00:00 CET