Subject Error messages and line numbers
Author Martijn Tonies

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:

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

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!