>>>>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...

Bruce,

You're right..it does have to do with table relationships... I just recreated this in the command window with two other views. One, which had multiple tables with persistent relationsips, behaved the same way. The other, with only one table, behaved as expected (ie returned records the first time).

I'd like to understand what is happening here if anyone can explain it.

Thanx
Terry