Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: how to get sql procedure parameters count and their type?

    Hi All,

    i am using DBLib and VC++. i want to know the number of parameters
    of a procedure at run time. is it posible if yes then how can i do this.

    thanks.

  2. #2
    Join Date
    Aug 2003
    Location
    Delft, The Netherlands (EU)
    Posts
    447

    Re: how to get sql procedure parameters count and their type?

    Use ADO's OpenSchema method with the schema ID: adProcedureParameters
    Make everything as simple as possible, but not simpler! - A. Einstein
    DB Problems? DB Explorer, BTrieve Re-engineering, DB Conversions & ETL? Conversion Tool

  3. #3
    Join Date
    Aug 2003
    Posts
    2

    Re: how to get sql procedure parameters count and their type?

    is there another way of getting parameter count other than ADO.
    actually we dont use ADO. some winodws api etc.

    thanks for reply.

    omar

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Check out INFORMATION_SCHEMA.ROUTINE_COLUMNS

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •