Alias not found woes?

[Redsz]

We are having trouble with one of our applications. There is a timer that fires the refresh of a form. It fires every 10 seconds.

Maybe once every other day error number 13 occurs ( "Alias is not found" ) The error only occurs on one of the tables?

Does anybody know of any rhyme of reason as to how or why this error occurs? Also note there is no where in the code that closes the table!

 

[craigsboyd]

No idea, there just isn't enough information for me to make an educated guess. However, given that the problem seems to be rather predictable for you... Put some code in your Error Handling routine that will trap for Error 13 and take appropriate steps to remedy the problem...it may be that the alias really doesn't exist and needs to be opened again, or maybe VFP is just losing it's mind and doesn't see that the alias is there. At the very least you could trap for the error and then dump all the information from the variables and workareas at that point into a text file and get a good look at what is going on at the time of the error.

[sub]craig1442@mchsi.com[/sub][sup]

"Whom computers would destroy, they must first drive mad." - Anon​

[/sup]

 

[Redsz]

I guess i should have been more specific. Craig what you provided me with is what i want . Ways to debug and get rid of this error. Thanks!

 

[dbMark]

I didn't see a sample error routine in this forum, there is one that you can probably use without too many changes on the older FoxPro forum faq182-4156.