I assign them in code prior to calling Open. Either that or I assign them
when it is already opened and IBO automatically detects the param change and
refreshes the dataset. If there is more than one parameter value to change I
use the BeginUpdate and EndUpdate so that I can set the values and have only
a single refresh.

A better place might be OnAfterPrepare than the BeforeOpen. But, I prefer to
discourage setting parameters in event handlers out of an intuitive sense I
have for things.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "Helen Borrie" <helebor@...>
To: <IBObjects@yahoogroups.com>
Sent: Friday, February 28, 2003 5:20 AM
Subject: Re: [IBO] Re: Refreshing parameterised IB_Query when params change


> At 10:48 PM 27/02/2003 -0700, you wrote:
>
> >Personally, if input parameter values are being handled in code I don't
> >think the events are an appropriate place to be handling them. I have
never
> >in all my years programming felt an inclination to assign parameter
values
> >in a BeforeOpen event.
>
> Where do you assign them, Jason?
>
> regards,
> Helen