Greetings,

Maybe this is a simple and basic question, but as we're new to SF, here it goes.



ProdutcTable (ProductBO)

- ProdCod (PK)

- VendorCod (FK) --> VendorTable (VendorBO)



Have a Maintenance Form with ProductBO(form bind) and VendorBO,

have also a Dialog to browse Vendors binded to VendorBO.



My question is how can I fill the VendorBO "on Navigate" so the info binded to it will follow it's parent FK.

The form contains no grids. Just binded fields.

I need the form to understand the relation and fetch the FKs data on ProductBO Navigate.



Thanks,



Alex

Hi Alex.

Have you had a look at the help file, under "Defining a Relationship Between Business Objects" ?

Also, to have a practical example, open the SampleCRMApplication, probably under C:\Program Files\MicroFour\StrataFrame\VB.NET Samples\CRMApplication, and open the CustomerMaintenance.vb, check the Customers and CustomerCreditCards BOs. Also, individualy open the CustomerBO and check its ParentRelationship property.

Let me know if you need something else.

Abraços.

 

Sorry, I meant the CustomerCreditCardsBO...

Hello Ivan,

The BOs are already configured like CRM sample app.

Our question is not how this relation works, but how to fetch data on Navigate, how to trigger the fetch of data on Navigate, as the original post.







And also I have lots of products without vendors, and in this case it will produce an error, because the framework tries to set an wrong equal statement (where int = string). This happens when the FK on the parent table is blank.

So our needs are:



01) Fetch child BO data from database only on parent BO navigation or

02) Avoid wrong where statements when child FK information is not present on parent BO.



Thanks,



Alex

Alex,



I think what you want is to handle the parent BO's navigated event. In that event, test if the FK is present and either load the child or clear it. E.g. If you have a ProductBO and an VendorBO, your Navigated event handler might look something like this:







Hope that helps!

G'day

It may be that I'm not understanding what you are trying to do, but I was looking for answers to similar problems a few months ago until the lightbulb came on. When you define the parent-child relationship (as indicated by Ivan) you then fill both the parent and child BOs with all the records from the related table/view when the form loads and SF takes care of it from there, you don't have to refresh the child BO. If there is too much data then you will have to do as Greg suggested.

Peter

Hi Alex.

Guess Greg has direct you already.

But, still, give a good look at the SampleCRMApplication's CustomerMaintenance code. Maybe you have already and I am being redundant here... if so, sorry!

In there, you will find many interesting guys: Customers_EditingStateChanged, Customers_Navigated, FillByParentPrimaryKey, SeekToPrimaryKey...

Um ótimo dia!

Yeah, the method I suggested is definitely directed toward reducing the data pulled across the network. Most of my users are remote

Hi Greg, thanks for your reply.

In the meantime I've already done the same, but my problem is to construct the navigated object in C#.

I'm doing like this:



The question I have now is how to construct it at Designer.cs



I don't know which parameters to send, and if is this the right way to grab the event in C#.



Thanks everyone for the attention, regards,



Alex

Yep, that is the correct way to attach to an event in C#.  The AddHandler and RemoveHandler keywords are not available in C#, so the overload of the +/- operators is used to add/remove method calls to delegate variables (events).  So, to add the event:

obj.EventName += new EventHandlerType(EventHandlerMethodName);

and to remove the event handler, it's the - operator.  I honestly can't remember whether you have to save off the created delegate in a variable to remove it or if you can just use the line above and swap the + for a -... not sure.

Also note that C# does not have the Handles keyword or WithEvents keyword like VB does, so when you double-click a button in the designer and it creates the Click handler method for you, it is explicitly adding the line above for the event handler within the .designer.cs file for the form.