When trying to use execute command dialog to execute an sql on a database 
connection, if there are some errors , it says like  " Invalid character at 
Position 89", it would be diffifuclt for users to count to 89th character to 
find out what exactly is the error. There needs to be better mechanisms to help 
user resolve his errors.
Reproducibile :

Run these SQL's, you would notice the difficulty.

On PointBase :

CREATE TABLE APP_USERS (
       USERNAME VARCHAR(20) PRIMARY KEY,
       PASSWORD VARCHAR(10) NOT NULL,
       USERTYPE VARCHAR(20) NOT NULL,
       FULL_NAME VARCHAR(40) NOT NULL,
       ADDRESS VARCHAR(50) NOT NULL,
       EMAIL VARCHAR(50) NOT NULL)


INSERT INTO APP_USERS
( "USERNAME", "PASSWORD", "USERTYPE", "FULL_NAME", "ADDRESS", "EMAIL")
VALUES ("sakthi", "sakthi", "doctor", "Sakthivel Gopal", "16 Network 
Circle",  "sakthi@sun.org")

Error Message Youy get :
"Unable to execute query, Only constant expressions allowed here at Position 
108".

(Solution is Change \" to \' (single quote) in values )

This would need user to count to 108 to find out the invalid character.
We need better resolution mechanisms.