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.
Set paraProdNo = nothing
Set paraProductName = nothing
Set paraDate = nothing
I have about thirty parameters objects and I try to save space.
Thanks in advance!
Use an array of parameter objects. Not sure if one can do arrays of objects in VB though . . .
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!