Subject RE: [IBO] Error messages and line numbers
Author Jason Wharton
> Here's something my users have been complaining about.
>
> Imagine this SQL statement:
> select * from artikels
>
> Table "artikels" doesn't exist.
>
> This is the error message I'm getting:
> Dynamic SQL Error SQL error code = -204 Table unknown
> ARTIKELS At line 4,
> column 6.
>
> Line 4?
>
> Now, the SQL Monitor shows this being sent to the server:
>
>
> SELECT ARTIKELS.*
> , ARTIKELS.RDB$DB_KEY
> from artikels
>
> (yes, 2 empty lines, then the statement all "mangled")
>
> Is there a way to get the correct error line here, for all kinds of
> statements?

You should set KeyLinksAutoDefine to false if you don't want this behavior.

Jason Wharton