Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Error 1547 (Cannot insert empty row) saving child bizob
Message
 
To
28/08/2002 16:08:27
General information
Forum:
Visual FoxPro
Category:
The Mere Mortals Framework
Miscellaneous
Thread ID:
00694642
Message ID:
00694810
Views:
12
Hi Chris,

trying to get behind your problem I fell over one question:
Who is initiating the Parent Requery(). This should't be fired when
you add a new child record ?

Lets say you have a good reason for the requery :
Have you tried what happens if you do a ChildBizObj.Save() before the requery. The requery() does no explicit save() itself.
I would just try to instantiate the Child itself and then do a new, fill the PK and FK and do a save just to get an idea if this workes without
linked BizObjs ?

Just a few ideas
Marcus

>I have a form with a Person primary Bizobj, and two child bizobjects, Address and Phone. Users want to be able to add/change/delete Address and Phone records from this form as well. No problem with change or delete, but adding a new Address or Phone gives Error 1547: Cannot insert an empty row from a view into its base table(s).
>In trying to resolve this, I found the error occurs because of a requery() of the primary Bizobj which requerys the children as well. Even though I've made changes to Address (Primary Key, PersonFK) and saved it, it is still being seen as empty by the requery. Any ideas how to work around this?
Marcus Alt
TRIA IT-Consulting GmbH
Working hard | for your success
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform