|
| | | StrataFrame Novice
 
Group: StrataFrame Users
Last Login: Today @ 1:01:15 PM
Posts: 67, Visits: 1,169 |
| | Philipp, Using a BO is for a maintenance purpose (All the business code is in the BO, all the connections against SQL server run from a BO to DL) And the intermediate SP (or execute as.. revert) is for a security purpose: I never expose a SP directly in the AppUser schema. |
| |
| | | StrataFrame Team Member
Group: StrataFrame Users
Last Login: 12/23/2008 11:10:40 AM
Posts: 232, Visits: 511 |
| | Yep, greg nailed it. Even though it is a scalar, you still want to return a recordset, hence the need for a SELECT. RETURN will exit the code loop immediately. It can return an integer, but that is typically used to show success or failure and isn't what you are looking for in this case. |
| |
| | | 
StrataFrame Novice
Group: StrataFrame Users
Last Login: Today @ 5:21:05 AM
Posts: 68, Visits: 163 |
| | Just letting you know it does indeed work now using SELECT instead of RETURN. Thanks again to Greg for pointing this out.  |
| |
| | | StrataFrame VIP
Group: StrataFrame Users
Last Login: Today @ 4:39:25 PM
Posts: 1,357, Visits: 3,617 |
| Glad you got it working and that I was of help!  |
| |
|
|