Skip to Main Content

Oracle Forms

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Populating a multi-record UNBOUND block

405394May 15 2006 — edited May 16 2006
Hello,

We have a situation where a form has 2 blocks:
A "Main" block and a child, detail block showing multiple records. When a value in a certain field changes on the main block, we open a cursor and populate the child block.

GO_BLOCK('child');
open cursor
loop and populate child block.

Both blocks are "unbound", ie they have their Database Data Block property set to NO and Query DataSource TYpe to "None".

The prpoblem is that if on the main block there is a required item that is null, GO_BLOCK('child') does not work.

Is there a way to jump to the Child Block, fill it and go back to the Main block?

Thanks
Chris
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 13 2006
Added on May 15 2006
1 comment
236 views