Hi

I have created my view and it updates the underlying table (for that datasession). I

TABLEUPDATE(1,.T.,'myview') or 
TABLEUPDATE(2,.T.,'myview')

I skip to the next record and the data in the underlying table (for that datasession) remains changed I

Requery().

I skip back to my record and Requery() again.

My data is now the same as it was before I modified it even though the table (in that datasession) still has the modified values and keeps them until the table is closed. I reopen the base table and it is still in the original state

What gives? How do I pick up the modified?

If I

TABLEUPDATE(1,.T.,'basetable')

I run into a

View definition has been changed (Error 1494)

everytime I try to acces that record and the only way I can get rid of it is to delete the record from the base table(s).

Please help

regards
Geoff Scott