StrataFrame Forum

Update of Child table Not sending Foreign Key to Stored Procedure and I Don't Know Why

http://forum.strataframe.net/Topic18908.aspx

By Marcia G Akins - 9/2/2008

Hi All.

On my winform, I have a parent-child relationship set up. I set up the business objects as specified in the help file topic "Configuring a Business Object Relationship". The children from the relationship are displayed in a DataGridView using a StrataFrame Business Binding Source. I am handling the filtering of the child table using custom code. Everything works except that when I make changes to any of the children, Strataframe blows up and tells me that I have not sent the foreign key field to my stored procedure. I thought that when I defined a parent-child relationship, Strataframe would handle the foireign keys for me automagically. Furthermore, the foreign key kield is in the child business object. What on earth could be causing this?

TIA

Marcia

By Edhy Rijo - 9/2/2008

Hi Marcia,

In your child BO instance in the form,  did you set the ParentBusinesObject to the Parent BO?

By Marcia G Akins - 9/2/2008

>> In your child BO instance in the form,  did you set the ParentBusinesObject to the Parent BO? <<

Yes.

By Marcia G Akins - 9/2/2008

Hi Edhy.

I apologize for wasting your time here - the field really WASN'T in the business object - I was populating it using an SP and my husband, the DBA, was giving me back the worng fields!

Once he fixed the SP, everything worked like a charm

By Dustin Taylor - 9/2/2008

I'm glad I refreshed! I was wracking my brain on this one trying to figure out why it wouldn't see that field, didn't think to ask if it actually existed w00t.

Just to make sure I don't leave any of your questions hanging, Is this the related error? http://forum.strataframe.net/Topic18910-7-1.aspx 

Regardless, glad you got it figured out Smile

By Marcia G Akins - 9/2/2008

Hi Dustin.

>> Just to make sure I don't leave any of your questions hanging, Is this the related error? http://forum.strataframe.net/Topic18910-7-1.aspx <<

Right in one Hehe. I finally got my parent-child form working perfectly. So now I am ready to start cranking out the rest of this application...

By Edhy Rijo - 9/2/2008

Marcia G Akins (09/02/2008)
Hi Edhy.

I apologize for wasting your time here ...

No need to apologize, I am constantly learning SF and I like to spend time in the forums.

Glad you found the fix, I know it can be a real pain and frustrated at times, I've been there many times Smile.