Results 1 to 2 of 2

Thread: Correct Coding

  1. #1
    Join Date
    Nov 2002
    Sacramento, CA

    Unanswered: Correct Coding

    I've been working with a db I just tookover, tring to normalize, clean code ect.
    In some moduals the previous admin opens a record set (ex. MyRS), does what is needed and in the end used just, Set MyRS = Nothing
    Other points he used, MyRS.Close then Set MyRS = Nothing
    And in some used just, MyRS.Close

    I've noticed that MS help also does it.

    Is this just a matter of 'coders choice'?
    Make the money, don't let the money make you.

  2. #2
    Join Date
    Dec 2002
    Préverenges, Switzerland
    i know what you mean.

    i have a habit to set = nothing for database/recordset/querydef and other large objects, but i do it just before exiting the sub/function that dimmed them.

    it's probably crazy! don't these things die a natural death when they go out of scope at the end of the sub/function.

    anyone know about this stuff?


Posting Permissions

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