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.

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?

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.

Edhy Rijo