Function Return Value to VB6

Hi all, I have a stored function that I call from a VB6 app. The function returns a "1" if successful and a "0" on failure. Obviously, I can see the result during development in a DBMS Output window but how do I pass this value to my VB app?


Thanks in advance,

Thom

Create a command object in VB,

Create a parameter and call the function.

better u put the function in a package and call it as
pkg.functionname from vb.


http://www.actionjackson.com/article...27/default.htm

http://support.microsoft.com/default...b;EN-US;321718

check the above 2 links,

HTH

Srini

Dim Rs as adodb.recordset.

rs.open "select FunctionName(Parameters) from dual",conn...

rs(0).value is what u want..

Try...

--Sathy