Please be aware that the SAP SQL Anywhere Forum will be shut down on August 29th, 2024 when all it's content will be migrated to the SAP Community.

Wondering if anyone would find this useful: when a ISQL Error pops up listing 'Syntax error near ',' on line 345....'

I believe it would be helpful to have a listed number sequence on the left hand side of the error window similiar to the numbered sequence in the SQL Statements window in ISQL.

When the query has lots of lines, spaces, etc, it's tough to track down the offending line unless you count down from the top.

What say? Any other suggestions?

asked 04 Mar '11, 20:13

zippidydo's gravatar image

accept rate: 0%

edited 04 Mar '11, 22:48

Justin%20Willey's gravatar image

Justin Willey


I agree, ESPECIALLY since the line number reported is counted from the top of the code in the error window, which is NOT necessarily the same as the top of the code in the ISQL edit window. The numbers diverge if ISQL is compiling multiple statements or batches; the error number refers to the current batch being compiled. ALSO, the error window should not be a modal response window, or if that is too difficult (since it is expecting a response), there should be a button to hive off a separate non-modal window containing the same information... or an error pane in the main display.

(05 Mar '11, 11:32) Breck Carter

(more) This stuff aggravates me many times a day as I run giant multi-file builds using ISQL.

(05 Mar '11, 11:32) Breck Carter

I can't believe it never occurred to me to wish for line numbers. I've often found myself wishing my cursor would just jump to the offending location when I click 'ok' to the dialog. The big exception to that wish, of course, is when the location turns out to be the end of all of my statements.

(11 Mar '11, 18:29) carolstone

Line numbers in the error dialog is great idea. We'll try to get that into a future release.

About carolstone's comment -- DBISQL 12.0.0 and later does exactly what you describe.

permanent link

answered 18 Mar '11, 10:34

Chris%20Irie's gravatar image

Chris Irie
accept rate: 46%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 04 Mar '11, 20:13

question was seen: 2,648 times

last updated: 18 Mar '11, 10:34