OraFAQ Forum: Forms » MASTER-DETAIL ERROR

Home » Developer & Programmer » Forms » MASTER-DETAIL ERROR

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

MASTER-DETAIL ERROR [message #178106]

Mon, 19 June 2006 07:05

RAY_HT
Messages: 155
Registered: May 2005
Location: Giza

Senior Member

I HAVE FORM WITH 2 DATA BLOCK (MASTER AND DETAIL)
WHEN FORM OPEN DATA INSERTED INTO MASTER BLOCK BY GLOBAL VARIABLE ,ID COLUMN INSERTED BY DATABASE TRIGGER USING SEQUENCE

DEAIL BLOCK SHOULD COPY THE VALUE OF ID COLUMN AS FORIGN KEY

BUT WHEN I COMMIT FORM ERROR RAISE

CANNOT INSERT NULL INTO DETAILBLOCK.ID COLUMN

ANY ONE KNOW WHY ????????

FROMS 10G

Report message to a moderator

Re: MASTER-DETAIL ERROR [message #178160 is a reply to message #178106]

Mon, 19 June 2006 15:17

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

Senior Member
Account Moderator

I guess that the problem is in a fact that detail block doesn't know the value which was inserted into the master table. This value, actually, doesn't exist in master form block either. As detail_block.id inherits its value from master_block.id, it is empty.

What to do? Either populate master_block.id in a form (instead of a database trigger), or - before navigating to detail block - post inserted data and requery master block.

I hope this could help ...

Report message to a moderator

Re: MASTER-DETAIL ERROR [message #178376 is a reply to message #178106]

Tue, 20 June 2006 21:07

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Search this forum for 'master detail when-create-record'.

David

Report message to a moderator

Previous Topic:	weird Issue with Forms/Reports 10g XE
Next Topic:	Frm-15103 subclass

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:41:54 CDT 2024