"Too many names used" error

[NathanGriffiths]

I'm using an application which generates an error of 'Too many names used' after it has processed about 500,000 records. The Help file tells me 'As a program was being loaded or a table was being opened, FoxPro's name table was overflowed. Too correct this divide the program into smaller modules'.
Can anyone explain what the 'FoxPro name table'is? Also any ideas on to go about fixing this would be appreciated!

thanks,

Nathan

 

[infinitelo]

Im not sure this is the problem, but it sounds like your application is calling itself. (recursive procedure call), foxpro has a limit on how deep it will go(5 levels i think)
without more detail on the application it would be difficult to troubleshoot.

hope this helps

 

[CDavis]

What version are you using? Some of the earlier versions had only allowed 25? tables open at a time. Is your code producing a number of temporary cursors?

 

[NathanGriffiths]

This is using FoxPro for Windows 2.6a

The main progam is scattering records from several tables to arrays and then passing these as parameters to various sub programs. As it does this for each record as it scans through the main table I'm wondering if this isn't giving rise to the error as it is repeatedly calling these sub programs?

The app is supposed to be taking one or more input files and merging them into one main table whilst creating a record of any duplicates. The sub programs do various validation procedures on the records passed to them.

As far as I can tell, the programs aren't creating any cursors, and they don't appear to be opening more than 10 or so tables at once.

Any thoughts?

thanks,

Nathan

 

[CDavis]

Are you releasing the arrays as you no longer need them? You might be creating too many variable names.