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).

>Jim,
>
>the problem here, and it seem Adam (the originator of this thread) has the same problem : I'm in a siuation that I receive SELECT's form 'outside' (via modem), of wich I don't know which tables they use, even not if their syntax is correct. So it is not possible to have the tables open before executing them.
>
>Pascal.