OraFAQ Forum: Forms » Master-Detail Relationship Problem

Home » Developer & Programmer » Forms » Master-Detail Relationship Problem (Windows XP)

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

Master-Detail Relationship Problem [message #324251]

Sun, 01 June 2008 01:32

il_jesromio
Messages: 3
Registered: May 2008

Junior Member

Dear All,
I'm a new member in orafaq goup and i'm a new oracle developer, i have a problem in my form. the form handles a master-detail relationship which is created correctly and works well but somtimes when i query the master block the details don't be queried !!! then when qyerying the master again, the detail block is queried well. I don't see any logical reason for this, Please help me.... Thank You alot

Report message to a moderator

Re: Master-Detail Relationship Problem [message #324253 is a reply to message #324251]

Sun, 01 June 2008 02:04

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

Senior Member
Account Moderator

Do you use a default, Wizard-created master-detail form? Or did you modify something by yourself? Triggers, block/item properties, ...? If you changed it, what was it and how does it look like now?

Report message to a moderator

Re: Master-Detail Relationship Problem [message #324254 is a reply to message #324253]

Sun, 01 June 2008 02:20

il_jesromio
Messages: 3
Registered: May 2008

Junior Member

The relationship is created by the Wizard,
The Primary key properties changes are:
Enabled - No
Required - No
Insert Allowed - No
Update Allowed - No
Query Only - yes
Query Allowed - NO
,i validete that the primary key is not null before committing the form, and there is a Post-Insert trigger which return the primary key value which has been inserted.

The Foreign Key properties are not changed yet and there are two triggers on that detail block which are:
When-Create-Record - Initialize some items.
When-New-Record-Instance - Populate a City List.

Report message to a moderator