Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is table valid?
Message
From
06/11/2003 10:39:26
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00846852
Message ID:
00847138
Views:
36
Thanks for the suggestions everyone. We already use ON ERROR and a class to open tables. I'm working on a web app right now that multiple clients use. I've been trying to crash it, so I created a text file, test.txt and renamed it to test.dbf. I found that when the code tried to open the invalid table ON ERROR worked and it didn't crash. But tables that were opened before I tried to open the invalid table were closed - so it did crash, but further along in the code when it tried to select a table that was previously open. I recently inherited this app so I'm still learning how it works. This morning I found another ON ERROR command that doesn't get called when you are in development mode. When the second ON ERROR command is set the second error is trapped and the app does not crash. And our error table and log files have enough information in it so I can figure out why the error occured. So I'm happy now. :)

>>Hi,
>>
>>Is there a way to check if a VFP table is valid before trying to open it? Using VFP 7.
>
>
>Hi Chris,
>
>There're a few MS KB articles about this:
>- http://support.microsoft.com/default.aspx?scid=kb;en-us;110968
>- http://support.microsoft.com/default.aspx?scid=kb;en-us;263902
>- http://support.microsoft.com/default.aspx?scid=kb;en-us;293638
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform