Re: Forms 6.0 - Item value getting Cleared!!
Date: Tue, 14 Dec 1999 11:20:42 -0500
Message-ID: <s5crgvo45349_at_corp.supernews.com>
[Quoted] Sorry to reply to my own post, but I found part of the problem. I looked at [Quoted] the Debug Messages again.
It seems the trigger sequence is :
ON-CLEAR-DETAILS
ON-POPULATE-DETAILS
PRE-QUERY
Since I was setting the ID in the MASTER block in PRE-QUERY,
ON-POPULATE-DETAILS was already called. Won't ever work! :-) I changed my
[Quoted] FIND form to load the data directly into the MASTER block (rather than
through a parameter). Now the data is getting where it belongs.
The new problem is that, after setting the value in the MASTER block, Forms [Quoted] 6.0 thinks it is a New record (which it will be when all the fields are filled in). When I switch back to the Master block, I get asked "Do you want to save the changes you have made?" before it goes to query the DETAIL [Quoted] block. Worse yet, it clears the ID field right after asking this question, [Quoted] to get ready for the new record it thinks it needs to create.
So, what is the correct way to code this? I'm trying to accomplish finding [Quoted] an ID, setting it in the MASTER block and causing the detail to auto-query.
-
[Quoted]
- Original Message ----- From: Eric Raskin <eraskin_at_paslists.com> Newsgroups: comp.databases.oracle.tools Sent: Tuesday, December 14, 1999 10:57 AM Subject: Forms 6.0 - Item value getting Cleared!!
> I've got an Forms 6.0 form with a master-detail block setup. Call them
> MASTER and DETAIL for this note.
>
> The MASTER block contains an ID, and the DETAIL block contains the details
> from another table for the ID.
>
> I have a third block (call it FIND) that does a query, allows the user to
> choose a row (by double-clicking on the row), and then returns the ID for
> the chosen row in a parameter. This works fine.
>
> I have a PRE-QUERY trigger on the MASTER block that copies the data
returned
> from the FIND block into the appropriate ITEM in the MASTER block.
> Debugging shows that this data gets where it belongs. The data looks good
> right before the end statement in the PRE-QUERY trigger.
>
> The problem is: After PRE-QUERY fires, and before ON-POPULATE-DETAILS
> fires, the item in the MASTER block gets cleared!!! I turned on "Debug
> Messages" (which shows the triggers that fire), and nothing seems to fire
> between PRE-QUERY and ON-POPULATE-DETAILS.
>
> What am I missing here? Why is the field clearing out?
>
> TIA
>
> Eric Raskin
> eraskin_at_paslists.com
>
>
>
Received on Tue Dec 14 1999 - 17:20:42 CET