Why I can't see my procedure code? How to display it
| User, date | Message |
|---|---|
|
Written by sunnyrainbow
3 months 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
3 months ago 3975 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
3 months ago 4 posts since Tue, 19 Feb 13 |
I'm using sql server 2008, and heidiSQL 7.0 |
|
Written by ansgar
3 months ago 3975 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
3 months ago 4 posts since Tue, 19 Feb 13 |
then that would be the installer(mirror), an exe |
|
Written by sunnyrainbow
3 months 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. |