Home » Developer & Programmer » Forms » how to restrict duplicates in multi record block
how to restrict duplicates in multi record block [message #86723] Tue, 26 October 2004 01:05 Go to next message
MD.Sirajuddin
Messages: 3
Registered: June 2004
Junior Member
Hi,
I have a multi record block block ,I want to restrict
duplicate values in that before saving .suppose if a focus in first record I entered some data and If I want to enter a any duplicate data it shuldnt be allowed.pls anyone give the solution for this .
Re: how to restrict duplicates in multi record block [message #86732 is a reply to message #86723] Wed, 27 October 2004 03:22 Go to previous message
Ani
Messages: 56
Registered: November 2000
Member
Hi,
pls use record groups.(c help for creating of record groups).
1. create a record group.
2. add_group_column to the record group.
3. add_group_row to the record group.
these act like temporary tables.u can store values in the record groups and retreive it when u enter the next record.
u can keep a check when u start entering from 2nd record eg(if :record_group_value=:txt1 then message "duplicate value entered".

All the best

Ani
Previous Topic: Regarding the LOV In Developer Forms
Next Topic: forms 9i
Goto Forum:
  


Current Time: Tue Sep 17 01:53:47 CDT 2024