Re: Detail -> Master query (FORMS4.0)

In article 15461_at_news.etc.bc.ca, Norm Russell <nrussell_at_etc.bc.ca> () writes:
>Hi there,
>
>I'm new to Oracle*FORMS and was wondering if it is possible to retrieve
>the master block data based on a query in a detail block?
>
>
> Norm
>--
>Norm Russell, Sr. Database Administrator | Phone: +1 (604) 655-4846
>B.C. Systems Corporation | Fax: +1 (604) 655-1029
>Dunsmuir Lodge, Education Technology Centre |
>P.O. Box 2040, 1515 McTavish Road | OV/ID: (BCSC02)NRRUSSEL
>Sidney, B.C. CANADA V8L 3S3 | E-Mail: nrussell_at_etc.bc.ca
>Disclaimer: The opinions expressed are my own and not those of my employer

Not using the default triggers. What I used to do, and probably will again, is create a control block for all the key fields of all the blocks on the forms - unduplicated by *domain*. That is, if one block has an INVOICE# and another has part of its primary key called DETAIL_INVOICE# there would only be one item on the control block called CTL_INVOICE#.

Then you set all the primary key fields to copy from their control block buddies. The KEY-ENTER-QUERY trigger needs to take the controlling block name and write it into a control block field. Then basically you write all the triggers necessary to NEXT-BLOCK; EXECUTE_QUERY; until your back where you started. NEXT/ PREVIOUS-RECORD triggers fill out the fun. I haven't had the fun of doing it in 4.0 yet, but I'm getting ready to move some from 3.0 and hope to use some of the new features to make it more general.

I hope this is at least food for thought. Take care.

Sincerely,

Martin Farber
Independent Oracle Consultant "A Jack of all trades and a slave to one."

                        |  NYNEX Science & Technology
                        |  500 Westchester Ave, Rm 1B-23
                        |  White Plains, NY  10604
                        |     -----------------
                        |  email: farber_at_nynexst.com
                        |  Voice: 914/644-2656
                        |    FAX: 914/644-2216