Best approach to set multiple parameterize objects to nothing (MS Access)

Databases
1

Hey Guys,

I am using adodb.parameter objects to insert and update records in a table (MS Access), and I was just wondering if you guys have a better way of setting the parameter objects to Nothing instead of typing the following for twenty times.

Example:
Set paraProdNo = nothing
Set paraProductName = nothing
.
.
.
Set paraDate = nothing

I have about thirty parameters objects and I try to save space.

Thanks in advance!

2

Use an array of parameter objects. Not sure if one can do arrays of objects in VB though . . .

3

I’m not sure that’s possible. I’m kinda new to parameter objects but I will give it a try when I have the chance. Have you done this before in other languages?

Thank you for the suggestion!

Javi10