distal-attribute
distal-attribute
distal-attribute
distal-attribute

Why I can't see my procedure code? How to display it

User, date Message
Written by sunnyrainbow
1 year ago
Category: General
4 posts since Tue, 19 Feb 13
Hi all,

I use the heidiSQL to connect to my database.

In the database there are already plenty of well-coded stored procedure.

I can see them in the left tree of heidiSQL, but when I click on the procedure, I can't see any code on the procedure console, the options, parameters and create code pages are all empty and it seems that I can create the already existing procedure from scratch.

But the procedures are definitely there, because I can write queries to execute those procedure from heidiSQL.

It's so weird that I can't see any code but I can execute procedures, and it's very inconvenient that I have to go back to SQL Server to see what parameter I need. Maybe I have been looking at the wrong place for procedure code this whole time.

So how could I let the heidiSQL to display the procedure code?
Written by ansgar
1 year ago
4793 posts since Fri, 07 Apr 06
What server is it, and what's the HeidiSQL revision you are using? I have recently fixed some stored routine bug, and introduced such a new bug along with that fix.
Written by sunnyrainbow
1 year ago
4 posts since Tue, 19 Feb 13
I'm using sql server 2008, and heidiSQL 7.0
Written by ansgar
1 year ago
4793 posts since Fri, 07 Apr 06
I meant the *revision* of HeidiSQL, not the major release version. But I guess that makes no difference here, as I did not manage to make the routine editor fully compatible to MS SQL yet. See issue #2490.
Written by sunnyrainbow
1 year ago
4 posts since Tue, 19 Feb 13
then that would be the installer(mirror), an exe
Written by sunnyrainbow
1 year ago
4 posts since Tue, 19 Feb 13
Thanks, anse,
that's exactly what I see when I want to use a procedure on HeidiSQL.
So this problem could not be fixed right now :(
 

Please login to leave a reply, or register at first.