I have the need to grab some records from 3 tables to do a lengthy process which includes looping that resulting query doing some seeks, etc. I am thinking that since this involve 3 tables that I could create a parameterized view in the DDT and then create a BO based on this view, now here is the question: How to fill this BO and pass the parameters to the view?



If you can post a quick seudo code I would really appreciate it, or if it is a better, easier solution that does not required to use a view, I am more than happy to listen.



I am thinking on using a BO to take advantage of the BO features for Seek, Order, etc, since I may need to loop through this data several times.



Thanks!

Edhy Rijo