Subject Re: [IBO] Re: Refreshing parameterised IB_Query when params change
Author Lester Caine
> In addition, in the b) situation, when you use OnParamSQL event, you
> have to invalidate the query to make this event work. All this "low
> level" IBO is confusing for beginners / intermediate, and often is
> error prone (you lately introduce OnParamSQL, and all your "refresh"
> becomes useless). So, for b), I asked for a "strong refresh" that

Marco - I think the problem here is that you are trying to
do things that already happen automatically, and so your
attempts to make them work are being hampered by other actions.

When you change a Parameter, RefreshOnParamChange will allow
the query to update itself. This will result in a
OnDataChange event which allows other changes to be managed,
or alternatively, if the detail tables are linked via
'MasterSource' and 'MasterParamLinks', (along with
RefreshOnParamChange on the detail queries), then there is
no need to be playing with the low level stuff at all.

While I could see a use for OnPrepareSQL, I have never used
it, along with 95% of the rest of the events. If the
database design is tidy, there should be no need to play
with anything other than the basic IBO functions.

Lester Caine
L.S.Caine Electronic Services