Subject ParamName, was Re: [IBO] Programmatically grant role to user
Author Helen Borrie
At 08:04 PM 3/03/2006, you wrote:
>hello Helen,
> > Then you can use the control to enter (or select, as the case
> > may be) the parameter value for the next Refresh, Execute, etc.
>so you could use this mechanism like a sort of search if the parameter
>value that you enter in the control is in the WHERE clause:

Yes, exactly. :-)

For example, say I have a couple of journal displays in ib_grids, one
showing credit transactions, the other showing debits. They are from
the same table and what you get in each depends on various parameters
in the WHERE clause, for simplicity's sake, let's say, for the Debits grid:

where tr_group = 'D'
and tr_type = :tr_type
and tr_date between :tr_date1 and :tr_date2

So, for the 'tr_type' parameter, I have a TIB_radiogroup that has all
the debit types as its items, that is bound to ParamName tr_type, and
for the two dates I have two tib_edits bound to ParamName tr_date1
and tr_date2 respectively.

You can have a lot of fun with these and you don't have to write any
assignment code. It is one of the most economical ways to limit the
amount of data you bring across.