Oracle Forms

Hi ,

How to avoid duplicate rows in a multi record block in oracle forms.
if i check from the table and write the code in when validate item using raise form trigger failure
it is not allowing me to go to other item .
help me to over come this
thanks
user_g
Hi, Thanks for the information but like to add some more points for the above
in form block have values like this
Here PK column is not displayed hidden , for the other items a row is not allowed to repeat how to achieve this

col1 col2 col3 col4
a 10 b 20
a 10 b 20 --> X not allowed
a 20 b 30

also these values are not saved in table
we have to check in the block

thanks
userg

dear all,

able to complete the task used a constraint combination of columns in the back end and for col4 i used a hidden item in the block(forms) to control the
duplicate rows in the block .

thanks for all the help,
userg

Edited by: g_user on Aug 26, 2011 8:16 AM