Results 1 to 2 of 2

Thread: local arrays

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Nov 1999
    Location
    Columbia, SC USA
    Posts
    374

    Post

    Here's a somewhat odd question. How can I assign a variable to a local array and then reference it later? I need to read through a delimited text file and compare each record to a record in a table to see if it already exists or not. Normally I would read through the text file each time and just add the record if it does not exist. But this is REALLY SLOW because the files are huge - like 250,000 records or more. The problem with using the local array is that I can only return the last assigned value. What can I do?

    Thanks

    Andrew

  2. #2
    Serge's Avatar
    Join Date
    Feb 1999
    Location
    Scottsdale, Arizona, USA
    Posts
    2,744

    Post

    You can create a global (public) array.
    Declare this on General Declaration of the Form or a Module:
    Public arrRecords()

    You can populate this array and later on use this array to compare against the table.

    ------------------

    Serge

    Software Developer
    Serge_Dymkov@vertexinc.com
    Access8484@aol.com
    ICQ#: 51055819



    [This message has been edited by Serge (edited 12-06-1999).]

Posting Permissions

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



Click Here to Expand Forum to Full Width