>I am not using remote views. I have using a VFP database.
>
>In VFP7 you can create a Select SQL query and make it updateable, what are the advantages and disadvantages of using a normal view over the Select SQL?
>
>The view will mainly be used to populate grids.
>

Ah, I misunderstood. The new READWRITE keyword makes Select SQL cursors writable, just like the Create Cursor command, but it does not update the underlying tables like a view does. This is useful if you need to calculate or populate certain fields in the cursor after the Select statement.