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

Stored Procedures?

User, date Message
Written by scar027
8 years ago
Category: General
1 posts since Fri, 16 Feb 07
Can HeidiSQL be used to work with stored procedures?
Written by fof
7 years ago
1 posts since Thu, 19 Apr 07
I know this is prolly an anoying question that is why I did not start a new threadsmile

Are there any plans for introducing stored proceedures? I love this MySQL GUI and as we use proceedures in a lot of our development I would love to see this in HeidiSQL.

Anyway .. just some user encouragement :)
Written by aljtdj
7 years ago
1 posts since Thu, 19 Apr 07
I will third that request.............. :shock:
Written by Davidoff
7 years ago
1 posts since Fri, 11 May 07
I use mysql.proc table for add/delete or update stored procedures or functions. :wink:
Written by Tapitas
7 years ago
1 posts since Wed, 30 May 07
So if I can
Written by rosenfield
7 years ago
127 posts since Wed, 24 Jan 07
Running stored procedures should work in the newest version (at some point the Zeos library was preventing it, now worked around).

In order to be able to actually create stored procedures, the HeidiSQL code needs an update to handle a client-side statement separator different from ';'. An easy hack is to replace ';' with something else, like '^' in helpers.pas / parsesql() [line 331-454, see link below], or even make it customizable via an input field or dropdown above the query area.
http://svn.sourceforge.net/viewvc/heidisql/helpers.pas?annotate=588

But really, the code should be updated to also handle two-character separators, since '//' is what most people use, AFAIR. That's slightly more complicated since the parsesql() algorithm needs an update, and noone's had the time to do that yet.
Written by jts
7 years ago
2 posts since Sun, 27 May 07
Has that been fixed? MySQL Browser (Yeach surprised) works fine when calling the procedures.
Written by ansgar
7 years ago
5045 posts since Fri, 07 Apr 06
Yup. See r674
Written by ansgar
6 years ago
5045 posts since Fri, 07 Apr 06
See the recently implemented routine editor in action: http://www.heidisql.com/forum/viewtopic.php?p=3094#3094
 

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