[SA 6.5.278] I can't "drill down" the code

[SA 6.5.278] I can't "drill down" the code

Dear SysOp
Apologize to bore you again. I have a little problem in visualizing the code of any view/procedure.
When I right click on the SMSS code editor "Sql Assistant | Show object DDL" then it appears the SA window showing the code of the view/procedure.
But, when I right click on the SA code window on a view/procedure contained in the previous showed view/procedure "Sql Assistant | Show object DDL" then the SA window became total empty, showing nothing. If I click on the "back" icon, then I can see the original view/procedure code. In summary, I can't anymore do a "drill down" in the procedure code, I'm forced to stop to the first level and I must copy the name of the view/procedure I want to see, paste it in the SMSS code editor and then starting again "from scratch". In previous version of SA this worked fine.

Hope I'm clear in my explanation

Thanks a lot for any help
Regs

Andrea

Hello Andrea. Is the other procedure located in the same database? Can you reproduce that with other procedures or objects?

Yes, it is on the same database. I can "drill down" on data (i.e., if I CTRL + click on a view already in the SA code window, it appears the grid with the data of the view), but I can't do that with the code.
It happens with any kind of object

Andrea

Any help?

Thanks

Andrea

Before you use Show DDL, please change the database context to the database where the procedure is located. If the database context is not the same and the procedure name is not fully qualified, SQL Assistant won't be able to find it.

All procedures are on the same database and the database context is already on the right database.

Please check what happens if you copy the code from Show DDL view to the editor and Ctrl+click the same procedure in the editor window. Does it show that procedure's DDL or the same kind of "cannot find" message?

If I paste the procedure name in the code window and then I ctrl+click, I can see correctly the procedure code. It's the "workaround" I'm currently using, but it's really boring

Unfortunately I'm unable to reproduce this issue. Could you please attach a couple of screenshots demonstrating the DDL code in the Show DDL code view, please circle the name you are going to Ctrl+click in tha view and a second screenshot demonstrating what you get after the Ctrl+click.

OK
Here you can find 3 attachment.
Attach 1: picture of the "CTRL+CLICK" on the procedure "Report.ReportComitato_MegaFILLER" -> the code is correctly shown.

Attach 2_before: picture of the function I'm selecting in order to see the code ("drill down") -> it seems that SA is correctly identifying the function

Attach 2_after: the "CTRL+CLICK" doesn't show any code (even if the name of the SA windows is correctly showing the name of the function selected)!

Any idea??

Thanks in advance

Andrea

I see now what you're doing. Thank you.

Please try the Ctrl+Click method, so called hot-track method for object names, instead of mouse-over balloons. Please let me know if you are not sure what I mean.

I understand what you are meaning, but both methods don't work!

Does that work for objects in dbo schema?

No
I have created a procedure called "dbo.sp_dummy", with a simple "select * from" code.
Then, I have created a procedure called "dbo.sp_dummy_2" with code "exec dbo.sp_dummy": if I try to "drill down" the code from dbo.sp_dummy_2 to dbo.sp_dummy, I receive the usual "blank screen".

I understand correctly what I had to try?

Andrea

I have installed the SA 7 beta and now the code "drill down" works!!!