DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Function Return Value to VB6

  1. #1
    Join Date
    Mar 2004
    Posts
    1

    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

  2. #2
    Join Date
    Jan 2003
    Location
    Hull, UK
    Posts
    220
    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

  3. #3
    Join Date
    Mar 2004
    Location
    India
    Posts
    72
    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
  •  


Click Here to Expand Forum to Full Width