deleted 9 characters in body

Source Link

edited Jan 23, 2015 at 13:36

35.2k
13
134
238

Hey guys I have this piece of code for running a Stored Procedure, and I was wondering if there is a way of cutting code like:

better title; cut out some noise; code works just as well in vba so I added the tag; created adodb tag;

Source Link

edited Jan 23, 2015 at 13:11

RubberDuck

31.2k
6
74
177

Shortening my code VB Calling Stored Procedures with Lots of Parameters

   uPar = .CreateParameter("@PropertyID", ADODB.DataTypeEnum.adInteger, ADODB.ParameterDirectionEnum.adParamInput)
        .Parameters.Append(uPar)
        .Parameters("@PropertyID").Value = Val(lblPropertyIDValue.Text)

   uPar = .CreateParameter("@PropertyID", ADODB.DataTypeEnum.adInteger, ADODB.ParameterDirectionEnum.adParamInput)
        .Parameters.Append(uPar)
        .Parameters("@PropertyID").Value = Val(lblPropertyIDValue.Text)

Hope someone can help.

Thanks

Shortening my code VB

   uPar = .CreateParameter("@PropertyID", ADODB.DataTypeEnum.adInteger, ADODB.ParameterDirectionEnum.adParamInput)
        .Parameters.Append(uPar)
        .Parameters("@PropertyID").Value = Val(lblPropertyIDValue.Text)

Hope someone can help.

Thanks

Calling Stored Procedures with Lots of Parameters

   uPar = .CreateParameter("@PropertyID", ADODB.DataTypeEnum.adInteger, ADODB.ParameterDirectionEnum.adParamInput)
        .Parameters.Append(uPar)
        .Parameters("@PropertyID").Value = Val(lblPropertyIDValue.Text)