General information
Category:
The Mere Mortals Framework
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only