Hi Tamar. Thanks for reply
If I issue command: Select * from MyView (With Bufferting =.t.) I get a syntax error
(Using VFP8)

Regards,
Gerard



>>Hi
>>In some of my forms I use Views to handle the Rows Maintenance, and when saving I update the Database from the Views
>>However, I notcie if I do Select * from MyView into Cursor MyCursor, I dont get any amendments to the view
>>(It seems to hold the original version of it)
>>
>>If I loop down through the View, the data is there fine (showing any amendments)
>>
>>Is there something I am missing that I am not getting the amended view into the Sql select statement
>>(I dont want to update the database yet but need to do some additional checking and Sql Select would be idel)
>>
>
>Probably buffering effects. Add:
>
>WITH (Buffering=.t.)
>
>to the FROM clause.
>
>Tamar