Retrieving stored procedure parameters for modification

  • 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

  • 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"

  • 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