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!

Questions to Reports gurus: placeholder column's "initial value"

372634Nov 19 2002

Hello,
I have a report with 2 queries, the master query contains some placeholder columns, and the detail query contains a formula column that sets values for these placeholders:

- MASTERQUERY: database columns, PlaceHolder1, PlaceHolder2, PlaceHolder3
|
|
-- DETAILQUERY (linked to MASTERQUERY): database columns, CF_PlaceHolder_Changer (change values of PlaceHolderX)

The problem is: for a particular record of MASTERQUERY, if the DETAILQUERY doesn't have any row then PlaceHolders are not set.
(They will keep the values from previous MASTER record). Is there any way that I can specify "initial value" for placeholder columns?

And another question: what is the formula attached to the placeholder used for?

Please help!

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 18 2002

Added on Nov 19 2002

#forms, #moved-from-devops

4 comments

253 views