javi10 — 2011-11-01T14:31:42-04:00 — #1
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!
wwb_99 — 2011-11-08T14:27:45-05:00 — #2
Use an array of parameter objects. Not sure if one can do arrays of objects in VB though . . .
javi10 — 2011-11-09T11:43:50-05:00 — #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!