Jim,

I had already thought of ths workaround, and I'm afraid that it's the only solution. The problem is : it's a workaround, not the best solution. Ideally, the select should return an error if i can't find a table just like it does when an syntax or other error occurs ...

Thanks for the help anyway ...

Pascal.


>Pascal;
>
>Well, this looks like a situation where you have to earn your money <g>. It's time to parse the SQL statement, pick out the table names, then make sure they are opened, or open them. If you can't open all the table, then don't execute the SQL.
>
>The parsing will be some work, but it should be doable. I would convert all returns and other white space to a single space and make it upper case. Then you need to find " FROM " in the statement, and grab averything between that and the next SQL keyword (" WHERE ", " ORDER BY ", " GROUP BY ", " HAVING ", that may be all of them).