Subject | Re: Refreshing parameterised IB_Query when params change |
---|---|
Author | Marco Menardi <mmenaz@lycosmail.com> |
Post date | 2003-02-28T21:09:56Z |
--- In IBObjects@yahoogroups.com, "Alan McDonald" <alan@m...> wrote:
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
> Marco, Have you checked to make sure that BeforeOpen fires when youexpect
> it to? I had to change my usual plan of attack on this because itdoes not
> fire e.g. in the detail dataset when the master scrolls. So it maynot fire
> when you expect it to either.Well, probably my english is not very good, but I'm sure that if you
> Alan
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