>>Hi Guys
>>
>>I have a Presentation Object on a Form Presentation Object that is based on a View
>>
>>When I try to insert a record into this view i get the following error message:
>>
>>"Cannot insert an empty row from a view into its base tables(s)"
>>
>>What can I do to solve this
>>
>>Thank You
>>
>>Gary
>
>This is usually because the view definition has updatable fields from more than one table. When you do a TABLEUPDATE(), VFP attempts to insert a record into both underlying tables. If you check your view, and find that only fields from a single table are set as updatable, remove all but the true updatable table name from the view's Tables property using DBSETPROP(). FWIW, my eView utility makes tweaking views like this much easier than wrestling with DBSETPROP commands. You can get here from the files section.
Erik,
I second on your reply.
I dropped really to request an enhancement to eview if you don't mind (great I use it instead of manually coding all those update code-thanks:).
Could you add a column to updatable field list to define actual sources so I could bypass manually entering "myDBC!myTable.myField" in code :) Actually none of the views I create are things that VFP designer could handle and so I rewind to your eview much, I would love entering sources there. If this is asking for too much just consider I didn't request :) Thanks.
Cetin