local arrays

[DrewDog_21]

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

[Serge]

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 (http://www.icq.com/51055819)



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