Results 1 to 9 of 9

Thread: Relase Array

  1. #1
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Unanswered: Relase Array

    How could an array be released from the Memory?

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    array = Nothing
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

  3. #3
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thanks for your reply, but it doesn't function. Did you try that?

  4. #4
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by hammbakka
    How could an array be released from the Memory?
    Hammy,

    What do you mean by "released"? Is this array an automatic variable or is it dynamically allocated?
    Back to Access ... ADO is not the way to go for speed ...

  5. #5
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    This array is a dynamic one.
    Thanks

  6. #6
    Join Date
    Sep 2003
    Location
    MI
    Posts
    3,713
    Quote Originally Posted by hammbakka
    This array is a dynamic one.
    Thanks
    Well there's "released" and then there's "RELEASED" ... Setting the pointer variable to Nothing (as noted before) will do the trick ... EXCEPT r123456 has the wrong syntax: Set Myarray= Nothing
    Back to Access ... ADO is not the way to go for speed ...

  7. #7
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1
    Thank you Owen, but still not function. Also the Array is a variable and not an Object, why should you use SET statement

  8. #8
    Join Date
    Nov 2003
    Posts
    1,487
    Use the Erase statement:

    Code:
    Dim myArray(10)
    ........blah, blah......
    ........blah, blah......
    ........blah, blah......
    Erase myArray
    Erase frees the memory used by dynamic arrays.


    Last edited by CyberLynx; 06-25-04 at 03:28.

  9. #9
    Join Date
    Oct 2003
    Location
    Ger
    Posts
    1,969
    Provided Answers: 1

    Thumbs up

    Thank you CyberLynx, it functions, I haven't known that nice order Erase

Posting Permissions

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