Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Error 1547 (Cannot insert empty row) saving child bizob
Message
 
À
28/08/2002 16:08:27
Information générale
Forum:
Visual FoxPro
Catégorie:
The Mere Mortals Framework
Divers
Thread ID:
00694642
Message ID:
00694810
Vues:
11
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform