StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Grandchild BO does not get foreign key value from Parent Insert

Grandchild BO does not get foreign key value from Parent Insert

Leonard P. — Wed, 17 Dec 2008 09:08:59 GMT

Hello,

I have a situation where I need to insert new rows of 3 related BOs on .Save. BOs parent/child relationship is setup correctly in the BO Mapper, and it follows the following path:

BO_1
P1_Key (PK)

BO_2 (Child to BO_1)
P2_Key (PK)
P1_Key (FK to BO_1)

BO_3 (Child to BO_2)
P3_Key (PK)
P1_Key (FK to BO_2)
P2_Key (FK to BO_2)

When I call Save to add new rows of all 3 BOs, the first 2 inserts complete successfully, but BO_3 insert fails, because it doesn't get newly inserted P1_Key. I realize that the design could be improved by simply getting rid of P1_Key FK in BO_3, but lets say for now that I need to stick to this design to accommodate some obscure requirements.
So, why doesn't BO_3 get P1_Key?

Thanks

RE: Grandchild BO does not get foreign key value from Parent Insert

Trent L. Taylor — Wed, 17 Dec 2008 09:08:59 GMT

Yes, the RegisterForeignKey method would be a great option here. The RegisterForeignKey method allows you to create as many foreign relationships as you need to any one (or multiple) BOs. This is the purpose for this method. The only difference from the single ParentBusinessobject funtionality is that when you adda new record, you must set the foreign key field's value (even if it is a new negative PK value) and then the RegisterForeignKey logic will handle everything else from there. Just to illustrate my point:

[codesnippet]MyParentBO.ForeignKeyField = MyInitialValue[/codesnippet]

RE: Grandchild BO does not get foreign key value from Parent Insert

Alex Luyando — Wed, 17 Dec 2008 08:41:45 GMT

Hi all -

Does anyone know if the use of RegisterForeignKey() would be a solution to this problem?

RE: Grandchild BO does not get foreign key value from Parent Insert

Charles R Hankey — Tue, 16 Dec 2008 17:53:51 GMT

I'm sure you'll get replies with a lot more SF knowledge than mine, but my first reaction would be I wouldn't expect bo3 to get the pk from bo1 automatically, since the parentchild relationship is only between bo2 and bo3. If you are getting bo2's pk as an fk in bo3 I'd say everything is working as designed. You might want to grab the bo1fk from bo2 on the save of bo3, but I dont think the framework is going to give you two fks.