>>>>You can trap any error
>>>>ON ERROR DO processerror()
>>>>and replace it with custom on, but in most cases you can just remove the source of error, e.g.
>>>>IF USED("mytable")
>>>>Select mytable
>>>>Endif
>>>
>>>An error handler doesn't stop the rather annoying behavior of presenting the user with an open table dialog when a line or SQL statement references an alias that is not open. The only way I know of to do this is just make darn sure your tables are opened before running the line.
>>
>>Not necessarily. If you run Select against tables in default directory Fox will open them itself.
>
>My point was that an error handler won't catch this. True, VFP will open the tables if they are in the path or the default directory, but in development/ testing, they aren't always.
Erik, that's Ok, but he didn't ask about SELECT :). 'Open file' dialog doesn't indicate error yet.
Edward Pikman
Independent Consultant