Hi,

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?

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com