Hi June,

One way is to parameterize the entire Where Clause so your view / query would be something like:

Create Sql View [ViewName] As [SQL without the Where clause] Where &lcSelectionCriteria

You the open the table with NoData clause as in:

Use [ViewName]In 0 Alias [AliasName] Again NoData

Now set the criteria

lcSelectionCriteria = " lflag = .T. And Not Deleted()"

= Requery("[AliasName]")

From then on you just need to change lcSelectionCriteria and requery the view to select a totally new record set.

Regards

>Mathias,
>
>Thanks for the reply.
>
>I solved the problem in a manner, I think, similar to what you are suggesting. I wound up making a single view with "lflag = .T. OR [bunch of conditions]" as the filter condition in the view designer.
>
>How do you set the selection criteria at run time for MM's dynamic cursors? I'm still using VFP 7, so that may be a later enhancement not available to me.
>
>Thanks,
>
>June
>
>>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