Hi Bhavbhuti,

You must set the property of your view.
You can use CURSORSETPROP() to set the property of your view.
example :
CURSORSETPROP("Buffering", 5, "CursorName")
CURSORSETPROP("SendUpdates", .t., "CursorName")
CURSORSETPROP("UpdatableFieldList", "Field1,Field2,...", "CursorName")

To update it use Tableupdate() function.


It is better if you create your view in the view designer.
If your using SQL Server as back-end database you must create a remote view
or local view if your using FoxPro table.