Post reply

Retrieving stored procedure parameters for modification

  • October 17, 2007 at 5:06 pm

    #118692

    An ADO question:

    Can a single stored procedure parameter be retrieved from the parameters collection, have its value modified, and replaced in the parameters collection so that the stored procedure can be executed again? I am using ADO in ASP with VBScript.

    Thanks,

    Steve

  • October 18, 2007 at 2:24 am

    #743030

    I think OLE/AdoDB has a "refresh" method that will try to get the parameters with datatype and direction for you.

    N 56°04'39.16"
    E 12°55'05.25"

  • October 19, 2007 at 6:28 am

    #743554

    Yes, Using a command object.

    With objCommand

    .Parameters.Item(1).Value = NewValue

    .Parameters.Item(2).Value = NewValue

    .Execute

    End With

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply