OraFAQ Forum: Forms » Using Sequence to populate Master/Detail block

Home » Developer & Programmer » Forms » Using Sequence to populate Master/Detail block

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

Using Sequence to populate Master/Detail block [message #82482]

Thu, 29 May 2003 10:56

Lisa Howlett
Messages: 1
Registered: May 2003

Junior Member

I'm using a pre-insert trigger on a master block to populate the primary key field with sequence.nextval. Need to know how to copy that value to a field in the detail block (foreign key). I've tried using sequence.curr_val and COPY built-in without success.

Report message to a moderator

Re: Using Sequence to populate Master/Detail block [message #83286 is a reply to message #82482]

Thu, 04 September 2003 00:36

Deepak
Messages: 111
Registered: December 1999

Senior Member

save sequence.nextval in a variable and populate it in detail block.

Report message to a moderator

Previous Topic:	Printing Oracle Forms
Next Topic:	Oracle Forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Apr 20 05:51:52 CDT 2024