Discussion Locked

return value of stored proc(vb6, sql s7)

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I am using the vb6 DataEnvironment (actually, a command) to execute a stored procedure. The stored proc takes 2 parameters and returns a value. This is how I execute my stored proc via the de:

DataEnvironment1.Command1 param1, param2

How canI gain access to the return value in my code?.

I've looked up for the answer in 2 good books to no avail.
thanx in advance.

1 reply

by dushy_ant

Use a Recordset Object.
Code :

set rs = new adodb.recordset
Recordset.Open DataEnvironment1.Command1 param1, param2

The Recordset will give you the value Back

This discussion is closed to new replies.