>>>>
>>>>SELECT Thisview
>>>>DELETE
>>>>IF TableUpdate(1,.f.,'thisview')
>>>> REQUERY('thisview')
>>>>ENDIF
>>>>*requery('thisview')
>>>>
>>>>
>>
>>Just a WAG: try to do a Locate or Locate Rest after TableUpdate(). You're still sitting on a deleted record. Don't know why would that affect the requery(), but I've seen strange things happening while sitting in the air.
>
>Thanx for the suggestion Dragan but no luck... I've tried locate and skip both before and after the tableupdate and get the same results. I've also observed this in VFP6.0.
>
>The results are the same in the command window or a running form. The key point to recreate the behavior seems to be that the view is made up of more than one table. The views I've tried were created in the view designer but the sql's seem straight forward enough.
>
>Still trying to understand whats going on.
>
>Thanx again,
>Terry
I have found that under Windows NT you have to execute
SELECT tablename
=RLOCK()
UNLOCK
after a table update in order to view the "current" information.