StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » BO's and Stored Procedures

BO's and Stored Procedures

Terry Bottorff — Sat, 04 Apr 2009 06:45:43 GMT

I have a Stored Proc that combines 2 Tables into one table (Like a Name Table and a Score Table) related by a NamePK to get a table that contains the names and respective scores. How do I attach this stored proc to a BO?

I have tried searching the forum and I can fill a BO if it is just a single table with a stored proc but with multiple tables I am not sure how to do that so the BO will know the structure of the resulting table?

TIA.

RE: BO's and Stored Procedures

Terry Bottorff — Sat, 04 Apr 2009 06:45:43 GMT

The link did the same to me and I finally had to copy and paste it to make it work.

RE: BO's and Stored Procedures

Charles R Hankey — Fri, 03 Apr 2009 18:00:58 GMT

Thanks. Maybe I'm doing something wrong but that link just takes me back to this page :unsure:

RE: BO's and Stored Procedures

Edhy Rijo — Fri, 03 Apr 2009 15:35:37 GMT

Hi Charles,

Yes I use this procedure for ReadOnly process where I like to use the SF ListView and also for XML files, this way instead of me maintaining the XML fields manually I simply use a dummy DDT profile and tell the BOM to use that DDT profile to build the BO schema. All this is explained in more detail in the link I provided in this thread before.

RE: BO's and Stored Procedures

Charles R Hankey — Fri, 03 Apr 2009 15:28:01 GMT

Edhy - if you create a structure like that in DDT (interesting idea) do you let the DDT deploy the structure to a table in the database? Is this for a basically readonly BO? Not sure how the update would work -are you just updating the primary table that fills the BO, as you would with a VFP remote view?

RE: BO's and Stored Procedures

Edhy Rijo — Fri, 03 Apr 2009 13:31:57 GMT

Hi Michael / Terry,
If you are using the DDT, you can create a table schema with all the columns that you want, then map the BO in the BOM to that table schema and then you can use your store procedure to fill that BO, as long as your SP return columns with the same names mapped in the BO you will be OK.

Also if you already have a BO created with some some columns, you can add the needed columns as custom fields properties with the same names as the columns returned by your SP and the BO will also fill up those custom field properties for you.

RE: BO's and Stored Procedures

Michel Levy — Fri, 03 Apr 2009 13:06:27 GMT

Hi Terry,

2 solutions, that I use in an app:

create a view as SELECT * from <your SP>, and map your BO on that view
create a table, let it empty (no data), map your BO on that table, and from within the BO, ExecuteNonQuery('your_SP'). Of course your SP need to delete all in the table, and then fill the table. You can now fill the BO from the table.

It woud be great if we could map a BO on a table function...

RE: BO's and Stored Procedures

Edhy Rijo — Fri, 03 Apr 2009 12:42:01 GMT

Hi Terry,
Check out this post [url=]http://forum.strataframe.net/Topic21580-8-1.aspx[/url] it will explain how to do what you want.