Greetings.



Two questions about business object mapping and FillByStoredProcedure( )...



1.) In a reply somewhere out here (I believe possibly from Ben) there was a indication that the BOM would allow mapping of a business object to a stored procedure as part of the 1.4.1 release. I'm not seeing anything that would allow that, and am running the 1.6.7. Was that option scratched, or is it hiding from me?



2.) Not withstanding new information I may get from replies to the above, I have a business object mapped to a SQL Server table. I will be giving users UI controls that will eventually trigger a call to BO Fill methods that will wrap calls to FillByStoredProcedure( ). Do the stored procedures called need to return datasets that are positional with respect to the columns the BOM knows about (i.e., data fields must be in the same sequence as the CreateTableSchema( ) in the BO's designer file), or have the same column/field names?



3.) Let's talk Browse! How would I go about customizing the Browse dialog to allow for searching based on columns not mapped in the BOM? This question will, of course, lead to discussions about the new OverrideSearchTableName/Schema, which I will look at. That may or may not be the solution, depending on whether--for my purposes--I can setup a view (or, I guess, views and programmatically change the Override.... properties just before calling the BD.showDialog()) that handles all possible searches the users will want to construct. If it does, great. If not, I'm hoping the flexibility of calling a stored procedure from the BD is feasible.



TIA

________________
_____/ Regards,
____/ al