SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Member
    Join Date
    Aug 2011
    Location
    North Carolina
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

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

    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. #2
    SitePoint Author silver trophybronze trophy
    wwb_99's Avatar
    Join Date
    May 2003
    Location
    Washington, DC
    Posts
    10,624
    Mentioned
    4 Post(s)
    Tagged
    0 Thread(s)
    Use an array of parameter objects. Not sure if one can do arrays of objects in VB though . . .

  3. #3
    SitePoint Member
    Join Date
    Aug 2011
    Location
    North Carolina
    Posts
    5
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    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


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •