Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Why does Fox stop responding when opening a table?
Any ideas why one of the two lines would *occassionally* cause FoxPro v5 to stop responding?
lnFileExist = adir( laFileList, "\\charlton1\apps\mastfile\data\produnit.dbf" )
use ProdUnit in select( "ProdUnit" ) shared
We have a very simple application which is run by upto 100 different people through the day, but typically only 13 would have it open at any one time. Over 300 searches are performed per day, so its not up there with high demanding Web sites.
Sometimes when people start the software FoxPro appears to stop responding. I would typically put it down to Windows, but..
Date/Time-------- USER COMMENT
27/10/00 14:10:17 prw - \\charlton1\apps\mastfile\data\produnit.dbf
27/10/00 14:10:53 prw - \\charlton1\apps\mastfile\data\produnit.dbf
27/10/00 14:11:31 prw - \\charlton1\apps\mastfile\data\produnit.dbf
27/10/00 14:14:51 clj - \\charlton1\apps\mastfile\data\produnit.dbf
27/10/00 14:48:31 prw - \\charlton1\apps\mastfile\data\produnit.dbf
The log shows that not only did PRW have problems, but so did CLJ. What could cause this to happen? They were obviously still able to log the fact that they were attempting to open the table (The log is store on another server)
What I'm basically after is a few hints to eliminate this problem. The software works well in the majority of cases, its just the odd balls which causes a few users some problems that may encourage them to stop using the program. I would like to help them, if I can.
Regards
Jason
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement