× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2015-05-14T17:37:29Z  · tomconrad last modified 2018-03-16T17:05:05Z

Nested Stored procedure: Indicate scope/which sproc the variables belong


customer request PM
Priority Minor
Complexity Moderate
Component Editor - Debugger for Sybase
Version Future

Nested Stored procedure: Indicate scope/which sproc the variables belong in the Variables and Watchers Tab

In debug mode, in case you have a nested stored procedure, while stepping into nested stored procedure calls the debug variables display window shows a list of all variables that have been created thus far through the entire debug session, not just the ones for the current stored procedure.

There is currently no way to identify the scope of the variables in the "variables" view to indicate which stored procedure the variable applies to. This is a new enhancement request to display the the current context of variables list.

To reproduce:
 
1. Connect to AWS and Sybase ASE 16.
2. Navigate to pubs2 database and expand the Stored procedure node
3. Select dbo.proc_main_nest and right click option Debug in Procedure Debugger
4. Add a breakpoint in Line #4 exec dbo.p_test
5. Execute, enter a value for the main proc and Step into (F7)
6. Click on the Variables Tab and you can see the variables from the main stored procedure
7. As you keep on Step Into (F7) you can see that If I am 2 levels down through a stored procedure stack, @myarg variable and cannot easily identify which sproc this belongs to.
 

There is no information available in the variables display window to indicate which one of these I should be adding to the watch list to capture the currently scoped operations. (Also, it is not uncommon to be operating with up to 100 variables and/or parameters within any one stored procedure. Once you are 2 or 3 nesting levels down then this rapidly becomes completely unmanageable.)

Solution: Can you add a new column in Variables and Watchers Tab which indicates the name of the stored procedure the variable belongs to?

1 attachment

Issue #13329

New
 
 
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