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...
Author
Message
Marcia G Akins
Marcia G Akins
StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)
Group: StrataFrame Users
Posts: 322, Visits: 529
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

Edhy Rijo
E
StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Marcia,

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

Edhy Rijo

Marcia G Akins
Marcia G Akins
StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)
Group: StrataFrame Users
Posts: 322, Visits: 529
>> In your child BO instance in the form,  did you set the ParentBusinesObject to the Parent BO? <<

Yes.


Marcia G Akins
Marcia G Akins
StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)
Group: StrataFrame Users
Posts: 322, Visits: 529
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

Dustin Taylor
Dustin Taylor
StrataFrame Team Member (652 reputation)
Group: StrataFrame Users
Posts: 364, Visits: 771
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

Marcia G Akins
Marcia G Akins
StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)StrataFrame User (496 reputation)
Group: StrataFrame Users
Posts: 322, Visits: 529
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...

Edhy Rijo
E
StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)StrataFrame VIP (4.6K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
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.

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search