StrataFrame Forum

Using BrowseDialog in conjucting with SProcs and Fillmultipledatatables

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

By Charles R Hankey - 8/1/2008

It all looked so easy in class - but of course the devil is in the details.



Right now I'm trying to figure out the best way to have a form show a browse dialog when it first comes up, with no data yet loaded (except for whatever might be necessary for parameters)



Then one parent record is selected from the browse results and the stored proc is called. I want this stored proc to fill all the BOs for a form showing a single parent record and listviews giving access to multiple children.



Trying to clarify my thinking about the parent bizobj here. Seems I need the new advanced browse dialog and then a separate BO for the parent that will hold one record after the user picks the parent in the browse dialog results. The browse dialog has its own logic for building the select to get the records of which the user will pick one and the stored proc will pull based on pk only for one parent record and related children.



Two questions for anyone reading along :



What is the best way to have the browse dialog show until a record is chosen and then switch to a page of fields for that single selected parent record and possibly listviews for children etc



Am I correct in thinking about two BOs for the parent - one for the browse dialog and one for the single selected record that comes back from the browse.
By Edhy Rijo - 8/1/2008

Hi Charles,

Take a deep look at StrataFlix, specially 

  • The MovieMaintenance.vb form in StrataFlix project
  • The MoviesBrowseDialog.vb in StrataFlix.UI project

These samples are real, very good one, could take you a minute or two to understand the whole process, but everything you are asking for is just right there.

I am analizing this sample and its concept and it is a great resource for showing how to use SF.

By Trent L. Taylor - 8/3/2008

Edhy is on target in regards to pointing you in the right direction.  In the StrataFlix sample within the Movies maintenance, if you will look at the "Find a movie" link, the code shows that you can first call the browse, and since the movie record has already been retrieved, the FillMultipleDataTables ignores the movies record and just brings back the child.  The People maintanance also shows this, but uses a SPROC instead of embedded queries.
By Charles R Hankey - 8/4/2008

Thanks, i found it on the PeopleMaintenance and notice the param to bring back just the children. Working on implementing all that now.