StrataFrame Forum » StrataFrame Application Framework - V1 » WinForms (How do I?) » Update of Child table Not sending Foreign Key to Stored Procedure and I Don't Know Why

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

Marcia G Akins — Tue, 02 Sep 2008 18:35:25 GMT

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

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

Edhy Rijo — Tue, 02 Sep 2008 18:35:25 GMT

[quote][b]Marcia G Akins (09/02/2008)[/b][hr]Hi Edhy.

I apologize for wasting your time here ...[/quote]

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 :).

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

Marcia G Akins — Tue, 02 Sep 2008 17:04:06 GMT

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...

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

Dustin Taylor — Tue, 02 Sep 2008 14:42:15 GMT

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 :)

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

Marcia G Akins — Tue, 02 Sep 2008 14:24:12 GMT

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

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

Marcia G Akins — Tue, 02 Sep 2008 13:32:50 GMT

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

Yes.

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

Edhy Rijo — Tue, 02 Sep 2008 13:05:14 GMT

Hi Marcia,

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