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
[email protected]
[email protected]
ICQ#: 51055819



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