>Our office has a decent error handler currently, but needs one more piece to identify.
>
>Lets say in a program we have
>
>select * from SomeTable into cursor test1
>
>and the "SomeTable" is not yet opened, or part of the path. By default VFP will bring up the Open table dialog and wait for a response for the user to pick a file, or cancel. Only then, with the error get trapped upon return.
>
>Q: Is it possible to turn the automatic Open table dialog off so it goes directly to the error handler?
>
>TIA
Probably, the better way is to check
IF USED("mytable") before firing SELECT-SQL.
Edward Pikman
Independent Consultant