ADODB and diffence between adParamOutput and adParamReturnValue

Posted on 2006-03-30
Last Modified: 2008-01-09

Just trying to set up a command object for the first time.

I cant seem to find any info on the difference between the direction type


I would be grateful for any info or links that would clarify this for me.
Question by:colindow
    1 Comment
    LVL 142

    Accepted Solution

    adParamOutput  refers to a parameter of the procedure that gives back a value
    adParamReturnValue  refers to the return value of the procedure itself, not the parameter

    create procedure testparam @param1 INT OUTPUT
      set @param1 = 99
      return 2

    to retrieve the param1 value of 99, you have to define a OUTPUT parameter
    to retrieve the return value of 2, you have to define a RETURNVALUE parameter

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Join & Write a Comment

    Introduction While answering a recent question ( in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
    I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
    Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
    Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now