Should show numeric position within statement
A Java SQL client for any JDBC compliant database
Brought to you by:
colbell,
gerdwagner
As you move the cursor around the SQL window, down the bottom it updates "[line],[position in line] [position in buffer]"
However, databases like Oracle, when an error occurs, tell you the position within the statement of the error, and if it's a multi-line statement , that is none of the above.
Since Squirrel is clever enough to put a box around a multi-line statement, clearly it's clever enough to know where the statement boundaries are, and therefore what position your cursor is within the statement. It would therefore appear to be fairly trivial to show the user the position of the cursor within the statement down the bottom. That would save a lot of aggrevation when trying to decypher Oracle errors.
Committed to our GIT repository. Will be available in future snapshots and versions.
Excerpt from change log:
'#1519 (in bugs): The caret/cursor position indicator at the lower right of a Session panel
now also shows the caret/cursor's position in the current SQL if applicable.
you're a star, anything i suggest gets implemented
Thank you. Nice to know it's appreciated. :)