Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Empty row?
Message
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Title:
Miscellaneous
Thread ID:
00188655
Message ID:
00188774
Views:
38
>I've got a form that is based on the bizobjmaintenanceform. On the first page, I've got my own business object (instead of using the default object). On the third page I have a different business object which is set as a child object. If I click on the "New" button, it adds a record (like it should) in the primary bizobj table. I can fill all the information in, then click on the third page I get a:
>
>"Cannot insert an empty row from a view into it's base table"
>
>error. I can reproduce the error if I browse the view associated with either of the bizobj's primary views, add a record then try to close it. I'm guessing it's because my primary index (iiD) field isn't preloaded with the new key, but I'm not sure why it's not getting set in my application. Any suggestions?
>
>Thanks,

Paul,

You're asking the right question. Whe isn't the primary key preloaded? Not sure about the exact process in MM. You should track a more conventional child to check when and how the key is preloaded.
If this is too complicated, you might want to set the default of iId to NEWID() in the view itself. I am doing all my views in xCase, that means that they cary over the default values of the tables they are based on. This works like a charm in Codebook.

José
Previous
Reply
Map
View

Click here to load this message in the networking platform