-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|