Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tad
Starting Member
31 Posts |
 Posted - 2002-06-07 : 11:38:52
|
| What is the correct method and sequence of events to have ado execute a parameterized sp, check the return_value of the sp and get the output parameters from the sp in a VB application.If you have time, could you post an example using the pubs or northwind database.Thanks. |
|
|
setbasedisthetruepath
Used SQL Salesman
992 Posts |
Posted - 2002-06-07 : 13:27:53
|
quote:
What is the correct method and sequence of events to have ado execute a parameterized sp, check the return_value of the sp and get the output parameters from the sp in a VB application.
to return output parameters or the return parameter you have to use the ADO command object. make sure the first parameter you add to the object's parameters collection is the return parameter.setBasedIsTheTruepath<O> |
 |
|
|
Doug G
Constraint Violating Yak Guru
331 Posts |
|
|
|
|
|
Need your ADO advice.