#869 support for stored procedures/functions

[Anonymous]

Originally created by: elacd...@gmail.com

What is the problem that needs to be solved (required)?
I'm kind of surpised that there isn't really any GUI support for stored
procedures for heidisql. I imagine it would be in the tree view.

What is the idea in abstract terms (optional)?
Show stored procedures in the treeview just like views and tables, each
with a different icon to denote what kind of object it is. 

Example workflow using the new feature (optional)?
You expand a database in the tree view and you see the tables, the views,
and the stored procedures in that database.  You can right click on the
database and choose "Create stored procedure" and up pops a box with the
sql you want to write in the stored procedure.  You can also right click
on a stored procedure in the treeview and choose "Edit stored procedure"
and up comes a popup window to edit the contents of the stored procedure.

What is a practical way to implement this idea (optional)?
I don't know, I don't know delphi.

[Anonymous]

Originally posted by: rosenfie...@gmail.com

Duplicate of issue #420.

Copy/paste from forum:
[quote]
Stored procedures are still at a pretty lame stage in MySQL.

For example, you can't create a procedure that takes a set of rows as input and
produces a set of rows as output.

Lots of other examples of missing basic features.

I guess none of the HeidiSQL developers has seen MySQL SPs as useful enough to apply
in their own projects, and therefore they have no need to implement support in the
HeidiSQL client either.
[/quote]

Status: Duplicate

[Anonymous]

Originally posted by: elacd...@gmail.com

The status of issue #420 says "Accepted".  From what you're telling me, it seems
like sp support won't be built into heididsql anytime in the near future.  What are
the plans for sp support?

By the way, I understand what you're saying about sp's and mysql, but what about
just adding the existing sp's to the tree view just to show that they are there in
the database?

[Anonymous]

Originally posted by: rosenfie...@gmail.com

Patches accepted? :-)