Subject Re: Refreshing parameterised IB_Query when params change
Author Marco Menardi <mmenaz@lycosmail.com>
--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
> Marco, Have you checked to make sure that BeforeOpen fires when you
expect
> it to? I had to change my usual plan of attack on this because it
does not
> fire e.g. in the detail dataset when the master scrolls. So it may
not fire
> when you expect it to either.
> Alan

Well, probably my english is not very good, but I'm sure that if you
carefully read my first and second post, you find that IS the problem,
i.e. BeforeOpen is fired when you .Refresh ONLY if "RefreshAction" is
set to raOpen ;)
I've noted following other lists with a news reader, that sometimes
seems that the server messes up messages thread, so you could have
miss it and I copy it here for your convenience:

"Well, refresh does open the query if you set "RefreshAction" to
raOpen, but this does not solve complitely the problem, since I often
user refresh for "refreshing" the grid content, and I need
raKeepDataPos, and when some conditions change (i.e. fiscal year) I
need to "refresh" the dataset in the way the new parameters are taken
in the query."

regards
Marco Menardi