>Hi guys,
> I have a program that gets the names of files store in a network directory and puts them in a dbf(table). Am using the function ADIR() to do so but if the records are more than 20,000, I get an error "Too many variables". Is there an alternative to doing so? This is the program :

SYS(2000) will return the list one at a time. For a whole discussion of this topic, including efficiency considerations, see my piece in the Advisor Answers column in the January '04 FoxPro Advisor.

Tamar