Thanks Rene,
One thing puzzled me is why did the data stop coming just because I made the cursor into a view?
Can I get the cursor itself updateable. This is very temp stuff, not much code worth it. ie. if it simplfies and works.
>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.