I have a SQL VIEW which joins multiple tables. Created a SF BO based on the view. Then a Custom BBS. Then a user control to fire off a Sharpshooter report. There are parameters on the user control and a button the user clicks to then run the report. The click event of the button does a SELECT with a WHERE clause to narrow down the data. My question is to confirm whether the SF Framework is waiting until I issue the SELECT to fill the BO, or does it fill it automatically initially with all the data and then refill it when I issue the SELECT.?

Like in FoxPro you could use a view with NODATA returned until you actual fill the view.

BO have no automatic mechanism to fill them (though there are some standard fill methods like FillByPrimaryKey, FillByParent, etc). This is because the BO is disconnected from the table(s)/view(s)/sproc(s) that actually get the data. There is no way for it to know how you might like to fill it. So, the only way it would ever get filled is if some code of yours actually fills it.



Hope that makes sense.

Thanks for your quick response.