>>>>>I have a routine that RE-INDEX about 54 files. When I go to reindex the files i get to reindex all of them. In other machines I get a message saying: TOO MANY FILES OPEN.
>>>>>
>>>>>Any clue on this message?
>>>>>Thanks.
>>>>Files that could be opened simultaneously is determined by OS and config.sys setting. A fox table with a CDX counts for 2 handles, if it has memo 3 handles and so on. The simpliest solution is to close the indexed one and open a new table so you will use minimum handles and don't have to check each stations files count.
>>>>Cetin
>>>W95 or NT?
>>What would it matter ? Both normally doesn't have that old dos limit. But if he's using a netware client software then probably files setting is at its default 40. Setting files a higher number in config.sys would eliminate the problem but should be done per station. Instead having the routine open one table per reindex is a better solution. George has already provided the sample code for that.
>>Cetin
>
>You set the FILES open in different places with NT as opposed to 95
I see your point. Config.sys or config.nt, but they're both limited to 255 max and for DOS apps (and his seem to be a DOS app - FPDOS 2.x ?). I think it's not a good idea to solve the problem by increasing files count. It should be done per station. I think it's better to optimize the routine to use one table at a time. Of course still for other purposes he might need to increase files setting and in that case he should do it differently depending on OS (even might be pure DOS + Novell ?).
Cetin