>>>Is it possible to requery a local view within a transaction. I know the syntax Requery("MyLocalView") doesn't work, but is there another possibility?
>>>
>>>W. Dieke
>>
>>As Jim stated, this won't work- but perhaps more importantly, why are you trying to do this? Transactions should only wrap update procedures, and not much (if anything) else. Trying to get data from a table inside a tranaction looks like a bad design choice...
>
>
>I have a form which starts with a Begin Transaction. In this form I lock one record. In my local view I have a filter which is a field from my locked table. When I change the filter, I wan't to requery my local view. I wan't to make changes to my local view.
A transaction should NEVER surround a wait state (ie- begin in a form load or init). It's just not what they were made for. Save your BEGIN TRANSACTION until just before you make your TABLEUPDATE().
Erik Moore
Clientelligence