W
Walter Enzor
I have been looking into Microsoft's Data Access
Application Block, and it has a procedure for calling a
stored procedure that only returns parameters and no
recordset. I would like to use this, but it accepts
parameters as a ParamArray, which, to the best of my
knowledge, can only be referenced by number. If I have a
large number of parameters, I'd like to be able to
reference them by name to improve the understandability
of my code. Does anyone have any ideas on what is the
best way to pass parameters to a procedure so I can
reference the returned parameter values by name? I still
need the procedure to be generic so I can pass any number
of parameters to it.
Thanks for any insight,
Walter Enzor
Elliott Wave International
Application Block, and it has a procedure for calling a
stored procedure that only returns parameters and no
recordset. I would like to use this, but it accepts
parameters as a ParamArray, which, to the best of my
knowledge, can only be referenced by number. If I have a
large number of parameters, I'd like to be able to
reference them by name to improve the understandability
of my code. Does anyone have any ideas on what is the
best way to pass parameters to a procedure so I can
reference the returned parameter values by name? I still
need the procedure to be generic so I can pass any number
of parameters to it.
Thanks for any insight,
Walter Enzor
Elliott Wave International