ASE version:
Aqua Data Studio 23.0.0
Build #: 59903
Built on: 2023-Jul-11 07:25:18 AM
Error Messages for Procedure Editor does not display line number
To reproduce ( in ADS):
Type in an editor window:
create table c(d int null)
go
create procedure aa
as
begin
update d set d=1 order by d
end
go
drop table c
go
When executing, error reported is
>[Error] Script lines: 3-8 --------------------------
Incorrect syntax near the keyword 'order'.
As the code is short, error is obvious (update does not allow order by). But in a big procedure, it is impossible to find where the error is
The same statement executed in Sybase ASE command line utility:
1> create table c(d int null)
2> go
1> create procedure aa
2> as
3> begin
4> update d set d=1 order by d
5> end
6> go
Msg 156, Level 15, State 2:
Server 'SERVOLAB', Procedure 'aa', Line 4:
Incorrect syntax near the keyword 'order'.
Here you can see the line with error clearly signaled (Line 4: update d set d=1 order by d)
Issue #15939 |
New |
Completion |
No due date |
No fixed build |
No time estimate |