Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Populate Multiple Rows in Form Builder
What I have done to solve this in the past is have the LOV return to :GLOBAL
variables then the WHEN-BUTTON-PRESSED trigger does an execute_query and a
PRE-QUERY trigger populates the fields from the :GLOBALs to retrieve the
correct records.
Kenny Gump
Evelyn wrote in message <37428ffc_at_news.ausmail.com>...
>Hi all,
>
>Thanks for taking your time to read my posting and hopefully u can help me
>to solve the problem.
>
>I have a Form that uses multiple rows (see attachment), I have another LOV
>button called Invoice. What i would like to do is when i click on the
>Invoice_LOV_button, it will automatically populate the rows in the Form.
>
>i have try to put my SELECT statements into the WHEN-BUTTON-PRESS trigger
of
>Invoice_LOV_button, however it's not working due to this multiple rows. i
>could done this for some other single line fields but having a big problem
>with multiple rows.
>
>I will be really appreaciate if u could help me solving this problem, i
need
>the solution asap.
>Thanks in advance!
>
>Regards
>Evelyn
>
>
>
Received on Thu May 20 1999 - 11:35:14 CDT
![]() |
![]() |