>>>In VFP 5.0a this sequence of commands returns no records the returns records..What am I missing?
>>>
>>>select thisview && parameterized view w/several records (buffering =5)
>>>delete
>>>tableupdate(1,.f.,'thisview')
>>>requery('thisview')&& returns none
>>>requery('thisview') &&returns records
>>
>>Are you in the Command Window? You can get a false zero count there...
>
>Have done it both in form and command window..zero count is correct, browse show no records.
>
>'thisview' has reference to 4 different tables but only one is updateable.
I guess it depends on table relationships, what happens when you delete a record from multi-table view...but I don't know why successive requeries get different results at runtime, never've seen that...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.