Hi,
I've realised, that error- indication is not always set to the correct position within a erroneous statement in SQL Window.
This reults in some confusion especially when handling with complex selects.
Because it's a bit difficult to explain I'll give a simple example:
I wrote a short script in SQL Window. Eache statement is terminated by semicolon. The first 4 statements only exists to create well-defined enviroment for test.
I execute these statements eache by position cursor and . Then position cursor within the select- union statement and execute statement.
The errorbox show ORA-00904 as expected - . The statement is highlighted, error- position is shown correct and cursor is just before.
I do nothing but again execute statement. Errorbox show ORA-00904. Select statement is still highlighted but the error- position is outside in the following comment -and also cursor.
When hitting again, the comment will be highlighted.
And what about once again? Errorbox- ok. Now select statement is highlighted and error- position is shown correct. But I see 5 tabs in the result section?
I use version 7.0.0.1050. In prefernces for SQL Window "AutoExecute queries" and "AutoSelect statement" are checked.
Hope you understand my problem.
Frank
I've realised, that error- indication is not always set to the correct position within a erroneous statement in SQL Window.
This reults in some confusion especially when handling with complex selects.
Because it's a bit difficult to explain I'll give a simple example:
I wrote a short script in SQL Window. Eache statement is terminated by semicolon. The first 4 statements only exists to create well-defined enviroment for test.
I execute these statements eache by position cursor and . Then position cursor within the select- union statement and execute statement.
The errorbox show ORA-00904 as expected - . The statement is highlighted, error- position is shown correct and cursor is just before.
I do nothing but again execute statement. Errorbox show ORA-00904. Select statement is still highlighted but the error- position is outside in the following comment -and also cursor.
When hitting again, the comment will be highlighted.
And what about once again? Errorbox- ok. Now select statement is highlighted and error- position is shown correct. But I see 5 tabs in the result section?
I use version 7.0.0.1050. In prefernces for SQL Window "AutoExecute queries" and "AutoSelect statement" are checked.
Hope you understand my problem.
Frank
