Re: Forms 4.5 Query ???
Date: 1996/02/25
Message-ID: <4gqonq$fp5_at_gossamer.itmel.bhp.com.au>#1/1
In article <312F2C15.7308_at_ix.netcom.com>, Sean Kubovcik <rbtkubo1_at_ix.netcom.com> says:
>
>I have a form that has master/detail relationship with the master on one canvas and the
>detail on another. I want to be able to query on the detail and go_block(master)via double
>clicking on the specific detail record's key and have the master canvas populated and
>queried on the selected detail record. I tried to have a double click event (on the detail
>record key) with:
>
> go_block('master');
> enter_query;
> :master_field := :detail_field; (record to query on)
> :execute_query;
>
>This would not work. I even tried to put the assignment in a pre_query trigger of the
>master block, but, that fails.
>
>What I am asking is how do I go to a block or form, initiate a query, assign data to a field
>and execute the query from another block or form?
>
>I would appreciate any input. Thanks in advance.
>
>
>Sean
>
>rbtkubo1_at_ix.netcom.com
I've done what it sounds like you are trying to do, but on one canvas,
which shouldnt affect it:
I had a non-base block and a base-block.
I had the user entering query criteria in the non-base (control) block,
and then a querry executing which populates the base block.
The best way to do it is to use the where clause property of the base
block.
ie make it something like
:master_field = :detail_field
This should meant that you can reduce your code down to
go_block('master');
execute_query.
note that you dont want to run an enter_query, as this would allow users
to enter query criteria in the master block, which you dont want.
HIH
Lee
------/\/\------+---------------------------------------------------
/ / /\ | Lee Levy, ISSD Systems Development, Del Code (34)
/ / / \ | BHP Information Technology, ACN 006 476 213
/ / / /\ \ | PO Box 261, Warrawong, NSW 2502, Australia
\ \/ / / / | PH: +61 42 75-5485 Fax: -5500 Tie: 8855-
\ / / / | Internet : levy.lee.ls_at_bhp.com.au
-----\/\/\/-----+---------------------------------------------------Opinions expressed are mostly my own, so give me some credit. Received on Sun Feb 25 1996 - 00:00:00 CET