AFAIK, you cannot avoid that dialog but you can open tables explicitly using USE commands before Select.

>Using VFP7.
>
>I have an ON ERROR routine in my application that traps for errors. However, there is one case where my ON ERROR does not trap for an error. Ir is when I issue a SQL select statement and the table in the FROM clause is not open or in the path.
>
>For example:
>ON ERROR DO myerrproc
>SELECT * FROM MyTableThatDoesNotExist
>***
>
>When this gets code is run, a VFP open file dialog appears. How can I avoid having this dialog appear?
>
>I know that I should ensure that the table in the FROM clause is valid, but how can I ensure that my ON ERROR routine gets called instead of the open file dialog?
>
>Thanks,
>
>Jerryt