Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Inserting Records Through a View
Message
From
28/12/1999 19:37:20
 
 
To
28/12/1999 15:29:17
General information
Forum:
Visual FoxPro
Category:
Visual FoxExpress
Miscellaneous
Thread ID:
00309437
Message ID:
00309616
Views:
25
>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 Moore
Clientelligence
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform