>Thanks for your help.
>Well as far as buffering goes, I did the buffering override in data environment and made everything to optmistic table buffering. The error I am getting now is that 'Table buffer for alias '...' contains uncommitted changes. I guess it did revert but doesn't know waht to do with the changes. Can you suggest a solution.
>Thanks again.

It sounds like ou are reverting some but not all changes in the cursor. Are you sure you got the right parameters with TABLEREVERT?

TABLEREVERT(.T.)

Should get them all. Also, are you manually opening a table that the view is based on? If so, you are also dealing with the double buffering problem. IOW, updating changes to the view are only updating them to the copy of the table that is also open in the same WA, and not to the table on disk.