Stored Procedures?

Can HeidiSQL be used to work with stored procedures?

I know this is prolly an anoying question that is why I did not start a new thread

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 :)

I will third that request.............. :shock:

I use mysql.proc table for add/delete or update stored procedures or functions. :wink:

So if I can

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.

Has that been fixed? MySQL Browser (Yeach ) works fine when calling the procedures.

Yup. See r674

See the recently implemented routine editor in action: http://www.heidisql.com/forum/viewtopic.php?p=3094#3094