>Select * from mytable (does not exist) will open a dialogbox.
>While this may be desireable in most cases, I'd rather test on en error.

Peter, use ON ERROR DO MyErrorRoutine and in your routine check for the error number and take appropriate action such as giving the user a custom message, ignoring the problem, or closing the app gracefully.