Information générale
Catégorie:
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement