Re: developer/2000: help! I can't get to trigger a query by a button!!

x95mok_at_wmich.edu wrote:
>
> Hi..I've got an extensive question ...I have be unable to solve for days..
>
> I would like to know how do I use a trigger button to do query from a
> table and display the SELECTED data in a scrollable list of several columns
> or several columns that are scrollable?
>
> - Any similar hints on how to solve this would be greatly appreciated..
>
> Please send you suggestions by e-mail : x95mok_at_wmich.edu
>
> Thank you.

Well, there are a number of ways to do this. You could create a base table block for the table you want to query. Then in your when_button_pressed trigger you need to

go_block('base_table_to_query_blk');
execute_query;

This will populate your block with data. If you want the data scrollable the when you create the 'base_table_to_query_blk' create it as a tabular, multi-record, and choose the scroll bar check box. You will then have a scroll bar and multiple records displayed.

IF you want to have each column scroolable seperatly then you could either repeat this proceedure with each column having a seperate block and each block having a seperate canvas. Then set each canvas to stacked, line them up and write a stored proc that navagates to each block and gets the data. Your button can just call the stored Proceedure when pressed.

As I said this is only one way. Perhapse the easiest but not the most memory effective.

Good Luck.

-- 

Craig Harper 
IFTN
(v) 415.583.4528
(f) 415.583.5536                                                                                                                                                                                                                               

Thinking is more interesting than knowing,
but less interesting than looking.