At 10:07 PM 8/03/2009, you wrote:

>Thanks Jason,
>
>Is it possible to access the relationNames information if the query is invalid ?
>
>For example if some of the tables mentioned in the query don't exist in the database ?

You can answer this question yourself.

Clue: if you succeed in preparing a query, you get all the information back. If you fail, you get an exception.

For example, try something like this:

select * from starship s
join planet p on p.x = s.y

You get these values back in the {properties} of EIB_IscError:

ISC ERROR CODE:335544569 {ErrCode}

ISC ERROR MESSAGE:
Dynamic SQL Error {SQLMessage}
SQL error code = -204 {SQLCode}
Table unknown
STARSHIP
At line 1, column 24 {ErrorMessage}

Helen