Hello,
I'm rather new to squirrel SQL using 3.5 and use it to connect to mssql
databases. when I have a long query (or multiple insert/update queries)
with errors (eg due to wrong formatting of content I have to import) I
cannot see the full error message. I only get
Error: Incorrect syntax near ' '.
SQLState: S0001
ErrorCode: 102
in the content pane of the error tab
and "Error occurred in"INSERT INTO ..... "
just above (see big black arrow in attached image).
I didn't manage to view the complete faulty SQL query (it is not the
first insert query, it is one of the following queries). The Error tab
is not enlargable and I cannot copy the error message to the clipboard.
I tried setting "Write SQL Execution Errors to log file" but this only adds
Error: Incorrect syntax near ' '.
SQLState: S0001
ErrorCode: 102
to the log file, not the actual SQL query.
Of course I could step by step execute the insert queries and check
where an error occurs but if you have 1000s of sql queries this is
rather tedious.
Can somebody help me out?
Ideally the content pane of the error tab shows not only an excerpt of
the wrong SQL query but also the line number where the error occurred to
ease finding it.
I have enclosed an attachment to make the problem clearer.
kind regards,
Tim Banchi
|