Re: Refreshing parameterised IB_Query when params change
Author
Marco Menardi <mmenaz@lycosmail.com>
Post date
2003-02-28T12:09:53Z
--- In IBObjects@yahoogroups.com, "Jason Wharton" <jwharton@i...> wrote:
[cut]
>
> 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.
Well, that event (BeforeOpen ) is the one Helen suggested many times
as the better place where do this, AFAIR.
I thought that was great having a centralized place that feeds the
query with the correct, up to dated, parameters value, so everywhere I
need "fresh data" I can refresh the query and the query gets the
correct values.
Like OnPrepareSQL is the correct place to "fine tuning" SQL selects
that can't be handled by simply parameters, would be good having a
similar place for parameters updates.
The problem is, as I discovered, that event is not always good.
So, what do you and Helen think about this request of "central
parameter management"?
As a general roule, this would ease developement, bug fixing and code
maintenance, I think.
Thanks
Marco Menardi