Re: Forms4.5 Duplicate Recs in block

>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
>
Store the record number you are in and the value(s) to check then -

First_Record
Check this one then loop to last record
checking each.
If successful go to original record
If duplicate found goto original record
and display error messsage.

Screen remains "as is" throughout unless you synchronize, which you don't want to do.

John Received on Wed Nov 19 1997 - 00:00:00 CET