In more than one place in my application, I will want to display a form, having the users enter some search parameters, then call a stored procedure (sp) in MSSQL and return a result set that will be displayed as a query. I am trying to figure out the best way to do this and can use some advice.
I was thinking I might want to CLEAN the BO in Aware, then call the SP and instead of having it return a result set, just populate the table, then have Aware run a query. Does this make sense, or would it be better to just have the SP return a result set, to a persistent BO in Aware, let aware populate it then display the records.
Waiting patiently to see how others have done this.
Thanks
Bruce
p.s. for those in the states who just celebrated Thanksgiving... gobble.. gobble....
