OraFAQ Forum: Forms » ORA-40508 with Master-Detail relationship blocks

Home » Developer & Programmer » Forms » ORA-40508 with Master-Detail relationship blocks (Forms 11G)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-40508 with Master-Detail relationship blocks [message #631273]

Mon, 12 January 2015 05:00

RaShi.Raj
Messages: 84
Registered: May 2014
Location: Bangalore

Member

Hi All,

I have 2 blocks, say block1(master) and block2(client) with Master-Detail relationship that I established during creating blocks. I have a item on block 2 which is mandatory to insert. So, I have when-validate-item on that item which throws error message when user tries to navigate to other items without entering any data. However, this error message appears 3 times if I click on any master block records except the record for which client detail is displayed. Any idea what's happening and how to get rid of this? Just to make sure when-validate-record on master block isn't causing this, I comment entire code on WVR but still getting the same error.

Thanks,
Rashi

Report message to a moderator

Re: ORA-40508 with Master-Detail relationship blocks [message #631275 is a reply to message #631273]

Mon, 12 January 2015 05:35

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Quote:

I have a item on block 2 which is mandatory to insert. So, I have when-validate-item on that item which throws error message when user tries to navigate to other items without entering any data

Why wouldn't you just set item's REQUIRED property to YES?

Report message to a moderator