>
What's wrong with Views or CAs?
>
>A simple REQUERY() or Cursorrefresh would do it.>
>Nothing. That works too but it is more difficult to implement if the where clause must change dynamically. Views are fine if the filter condition is always on the same field - that is "where somefield = somevalue". But is the where clause must change on the fly - "someother field = someother value" - it is a little easier to implement by using a cursor.
View and macrosubstitution will do pretty fine. (Engine to 70 for what I remember). It's a little bit cruel, I know.
Anyway, I would suggest the following:
The recordsource is a view
The source of the view is a cursor.
The cursor is created on the fly and the view will be refreshed afterwards.
So the view will deal with all needed to refresh the object, and you are free to generate the cursor.
Normaly I use a CA. They encapsulates the query in a much better way.
Never mind. As long as it works ... <g>
Agnes
AFK
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]