>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