Hi June,
You could a single parameterized view. You can then set the selection criteria ie [ a bunch of conditions ] at run-time. Your [ a bunch of conditions ] could be as simple as "lflag = .T." and requiry the view.
Just make sure you issue NoData clause when you first open the query.
You could the do you replaces and follow it it with a TableUpdate().
Regards
>I want to reset a flag in a table, then set it selectively based on certain contents of a filtered view.
>
>The old way would be:
>
>replace all lflag with .F. in table for lflag = .T.
>replace all lflag with .T in table for [ a bunch of conditions ]
>
>I made two views of the table, one filtered on lflag = .T. and one filtered on the "bunch of conditions".
>
>Do I need two bizobjs to do the updates or can I somehow make do with just one, and somehow tell the bizobj which view is "in control"?
>
>Or is there a third option that is an even better way to do this?
>
>Thanks,
>
>June
Mathias Banda
Time is longer than a rope.