Re: Forms:Is This Possible??

In article <8dkaga$d7s$1_at_nnrp1.deja.com>,   sboucher_at_my-deja.com wrote:
> I have a project where the user will enter search criteria, usually a
> name, and a result set will be returned including an account number.
>
> The user then wants to be able to use the account number to get more
> detailed info. Preferably the user wants to click or highlight the
> account number and go directly to the detail without rekeying
anything.
>
> Do I need to add a button beside each query result and grab the
account
> number from the text box. Or is there a more professional way of
> handling this problem.
>
> Using Oracle 8i and Developer 6.0 on WINNT4.0
>

Use a master detail block with deferred coordination.

For example, I created a block on the DEPT table. I then created another block on the EMP table and created a master detail relation between the two. I set the coordination between the 2 to be deferred (else everytime I changed rows in the DEPT block the emp block would be updated automatically for that deptno).

I then put a WHEN-MOUSE-DOUBLECLICK trigger on the deptno field in the dept block. This trigger has in it:

go_block('emp');
execute_query;

The master-detail object does all of the work. I told it the EMP block is driven by the DEPT block based on the DEPTNO field. Just by going to that block and executing the query -- the relevant data from DEPT was copied into the EMP block and the query was executed -- showing me the details for that deptno.

> Thanks
> Scott
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

--
Thomas Kyte                              tkyte_at_us.oracle.com
Oracle Service Industries
http://osi.oracle.com/~tkyte/index.html
--
Opinions are mine and do not necessarily reflect those of Oracle Corp


Sent via Deja.com http://www.deja.com/
Before you buy.