Re: forms question

If there are only two options you could split the base-table block into two blocks. Each option has his own block.
The only thing you have to do is when the user selects one of the radio buttons switch the blocks on the screen. You could fill both blocks at once by issuing an execute_query for both blocks together. Show the user one block and set the radio buttons according to this block. If the user selects the other button just switch the block.
Because the blocks are queried almost together the second one uses the sga-blocks of the first to fetch it's data.

This way you only once select all the data and prevent that after each button select the data has to be refreshed. It's not as fast at startup but afterwards it much much faster. The switching of the blocks is done with switching the (forms) views.

sasubram_at_cisco.com wrote:

> hi people.
> I am having a small problem in my form. I don't know whether there is
> any solution or not for this.
> before I go any further, let me explain how my form works. it has two
> blocks 1.dummy_block(no base table) 2. main_block(base table is a view)
> in the dummy block I have a radio_button field which has two child.
> Based on the user's selection of radio button I have to query the
> main_block. for eg. if user chooses radio_button1 then query all records
> for export_id = 1(doing it by setting the block_property)
>
> It takes almost 45 seconds to bring back 10 to 15 records when the user
> changes the radio_buton.
> My project_leader wants me to query all the export_id together and then
> do the manipulation. I have a post_query in the main_block which selects
> the description.
>
> Now What's the best way to bring back all the results at once (by
> setting default_where as 'export_id in (1,2)'and display 1 & 2
> separately whenever user changes the radio?
> I tried so many ways... But I am really frustrated now.
>
> when I run this query in the sqlplus session, it doesn't take more than
> 1/2 a second. we know it's network problem and that's why she is asking
> me to reduce the trafic by going to the db only once.
>
> please send me some suggestions.
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Fri Jul 23 1999 - 11:58:35 CEST