Results 1 to 2 of 2

Thread: local arrays

  1. #1

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


    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?



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


    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.



    Software Developer
    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