StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Parent child bo's edit records

RE: Parent child bo's edit records

Trent L. Taylor — Mon, 22 Jan 2007 08:56:58 GMT

[quote]When ChildBo.Add() called, ParentBO.PK is still null.
[/quote]

Then you have one of two issues. First, you have set the AllowNullValuesOnNewRow property on the business object to True. Otherwise you will NEVER have a NULL value on a BO when a new record is created. Second, if you have a primary key defined on the table, and the PrimaryKeyIsAutoIncrementing property is set to True, this value will be automatically managed for you. Until saved to the server, the PK values will be negative numbers.

[quote]Update FK during BeforeSave event?[/quote]

No. StrataFrame will manage this for you automatically if you setup the relationships. On the child BO, set the ParentRelationship property. Once dropped on the form, set the ParentBusinessObject property to the appropriate parent BO and the FK value will be managed for you.

Note: This is shown in many of the samples. I recommend looking at the Sample CRM application sample that was installed with StrataFrame.

Parent child bo's edit records

Jon Olson — Mon, 22 Jan 2007 08:56:58 GMT

I have a form with two tables that have a parent child relationship. I also have added the maintenance toolstrip. When I use the navigation buttons both tables update the fields as I would expect. When I select edit though it only edits the parent table? Can I have it automatically have the child edit as well.

RE: Parent child bo's edit records

Chan — Sun, 21 Jan 2007 21:43:37 GMT

Hi,
I tried this approach to add records. But I hit error when save. It is caused by

1. My ParentBO is PKIsAutoIncremented = true
2. When ChildBo.Add() called, ParentBO.PK is still null.

So, what is your suggestion? Update FK during BeforeSave event? Or any better way to do this?

Thank you

RE: Parent child bo's edit records

StrataFrame Team — Mon, 20 Nov 2006 16:08:05 GMT

No problem.

RE: Parent child bo's edit records

Jon Olson — Mon, 20 Nov 2006 16:07:29 GMT

okay that worked thanks for the quick reply

RE: Parent child bo's edit records

StrataFrame Team — Mon, 20 Nov 2006 16:00:22 GMT

What is the value of IncludeInFormEdit on the form, and IncludeInFormEdit of the child busines object?

It should work if you set the IncludeInFormEdit of the form to AllBusinessObjects or set it to DeterminedByBusinessObject and set the IncludeInFormEdit of the child business object to True.

RE: Parent child bo's edit records

Jon Olson — Mon, 20 Nov 2006 15:58:29 GMT

I have all those set but it still doesnt work.

RE: Parent child bo's edit records

Trent L. Taylor — Mon, 20 Nov 2006 15:41:07 GMT

Yes. Set the Form Include properties and the include properties on the business objects. Read the help topic in the StrataFrame Help: Business Layer -> Configuring a Business Object -> Form Include Settings