× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
Vikram001 Pacharne
VikramPacharne(*) reported 2013-11-19T09:34:12Z  · NielsGron last modified 2014-06-24T20:49:01Z

Error Messages for Procedure Editor does not display line number for SQL Server 2005,2008 and 2012


Dev
Niels Gron
NielsGron
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component Editor - Procedure
Version Future - 0.1

Aqua Data Studio 15.0.0-dev-37
Build #: 34859
Built on: 2013-Nov-14 02:04:45 PM
O.S. : Win 8.1(64 bit)
Database : MS SQL Server.

Issue: Error Messages for Procedure Editor does not display line number for SQL Server.

Steps to Reproduce : 

1. Connect MS SQL Server 2008 Database.
2. Expand tree node of Database.
3. Expand the Stored Procedures node.
4. Create Procedure db_accessadmin.multiplication

e.g.  

CREATE PROCEDURE "db_accessadmin"."multiplication"
(
@FirstNumber int ,
@SecondNumber int 
)
AS
begin
declare @setval int
select dbo.[MultiplyofTwoNumber](@FirstNumber, @SecondNumber)
end
 
5. Right click on procedure db_accessadmin.multiplication and Select option "Edit in Procedure Editor"
6. In a script type a few characters as in attached screenshot.
7.Compile the procedure.
Here it is observed that,the line numbers for error location is missing.
SQL Server 2000 displays the line number correctly.
1 attachment
  •  
  •  
  • No shares
  •  
All Comments (0) Change History
Sort 

Issue #10828
Closed
 
 
Completion
No due date
No fixed build
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017