Stored Procedures?
| User, date | Message |
|---|---|
|
Written by scar027
6 years ago Category: General 1 posts since Fri, 16 Feb 07 |
Can HeidiSQL be used to work with stored procedures? |
|
Written by fof
6 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 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 :) |
|
Written by aljtdj
6 years ago 1 posts since Thu, 19 Apr 07 |
I will third that request.............. :shock: |
|
Written by Davidoff
6 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
6 years ago 1 posts since Wed, 30 May 07 |
So if I canīt create procedure with HeidiSQL, and my database has already a couple can I still call them?? I was using EMS Lite Manager but it isnt free :cry: |
|
Written by rosenfield
6 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
6 years ago 2 posts since Sun, 27 May 07 |
Has that been fixed? MySQL Browser (Yeach  ) works fine when calling the procedures.
|
|
Written by ansgar
6 years ago 3958 posts since Fri, 07 Apr 06 |
Yup. See r674 |
|
Written by ansgar
4 years ago 3958 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. |