Any ideas?

For a View, you need to have a Pk into it, and the override the primary key once in the BO Mapper, have a look at this picture:

SELECT     dbo.Certificate.Cert_number AS Certificate, dbo.Certificate.Cert_inbound_date AS date, dbo.Certificate.Cert_trans AS Tr, dbo.Certificate.Cert_net AS net,
                      dbo.Customer.cust_name AS Customer, dbo.Certificate.Cert_trk_license, dbo.Certificate.Cert_Front_trl, dbo.Certificate.Cert_Rear_trl,
                      dbo.Commodity.Commod_name AS commodity, Customer_1.cust_name AS Carrier, dbo.Certificate.PK_Certificate
FROM         dbo.Certificate INNER JOIN
                      dbo.Commodity ON dbo.Certificate.FK_Commodity = dbo.Commodity.PK_Commodity INNER JOIN
                      dbo.Customer ON dbo.Certificate.FK_Customer = dbo.Customer.cust_pk INNER JOIN
                      dbo.Customer AS Customer_1 ON dbo.Certificate.FK_Customer2 = Customer_1.cust_pk

In the sql management studio this will return the expected data. dbo.Certificate.PK_Certificate is the primary key in dbo,Certificate, this was the field I specified in the BO mapper, is that correct. Still no results in the browseDialog.

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

public void Fill()

{

string s = "select * from Cert_listing";

FillDataTable(s);

}

Cert_listing is the name of the view on the server.

SELECT     dbo.Customers.cust_pk, dbo.Customers.cust_FirstName, dbo.Customers.cust_LastName, dbo.Customers.cust_City, dbo.Orders.or_ponumber
FROM         dbo.Customers INNER JOIN
                      dbo.Orders ON dbo.Customers.cust_pk = dbo.Orders.or_cust_pk

named it Customer_po

in the Browse dialog example I aded a BO customer_poBO

Set up the BO to be populated from the server

Overrode primary key specification

put Cust_pk

rebuild all

rebuilt application

added BO to the form

changed the browsedialog to look at it and set the search field appropriately

Put the following code in the toolstip cliked

if (this.printToolStripButton.Pressed)

{

}

set a break point

ran the application

In the object viewer for each field in the BO it says This.(whichever field) threw an exception of type'MicroFour.StratFrame.Business.businessLayerException'

Can you duplicate this?

You mapped your view to Customer_poBO, which is fine, and the cust_pk is been returned, perfect.

Your Customer_poBO has a fill method selecting records from the Customers table, I guess it should be from your Customer_po view. Although you won't need to fill this BO to have it working with the BrowseDialog. The BrowseDialog will fill it with the results it gets depending on your search criteria.

Your form has the CustomersBO1 as the PrimaryBusinessObject and your controls are bound to this BO properties. This is just fine.

But then, your BrowseDialog has the Customer_poBO1 as the BusinessObjectToPopulate. This is not a problem, but once your BrowseDialog brings your search results, this is the BO that will be populated, and not your form's BO, CustomersBO1.

Still on your BrowseDialog, you haven't set the SearchFields, and this will definetely throw an error at run time. You need to set them:

Once you get this working, you will have your Customer_poBO1 populated as soon as you Close the BrowseDialog after having your search results listed and pressing OK. At this stage, you need to use the BrowseDialogClosed event as I have tried to show you earlier on this following post:

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

Why that? Because your results will have the Customer's PKs that you want to show on your form, so you need to get all the PKs from your populated view and fill your form's primary BO with the records that match this list of PKs from your view.

There might be some concepts you could be missing on how the BrowseDialog works. If you haven't done so, the Tutorial on the Help files could help you get a general idea of it. It is under "Application Framework / Getting Started / Tutorials / Creating a WinForms App"

Hope it helps.

You are dealing with its RowChanged event, you are on the right path there, but remember you are not dealing with the Customers BO at this moment, but with the view instead. You can use the current view row PK to go to the Customers table and get the info you are looking for, though. For the sake of making your BrowseDialog work first and get the idea of it, try to comment those lines and focus on getting the BD work and populate your form's primary BO with the rows from your BD results. I did it over here and the BD list populated just fine from the view.

Strange result you are getting there... over here, I have created the same view you did over there and haven't done anything to your sample besides creating an enter to the BrowseDialog SearchFields property with the cust_FirstName.