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

Couldn't find the toolbar option for stored procedure

User, date Message
Written by Jack_Tauson_Sr
9 months ago
Category: HeidiSQL portable
5 posts since Fri, 02 Aug 13
This may be a silly question but I'm unable to find the stored procedure toolbar in my HeidiSQL. Could anyone tell me how can I do that? I'm using HeidiSQL 7 version.

The below link demonstrate one stored routine editor but I couldn't find it in Version 7.

http://www.databasejournal.com/features/mysql/article.php/3826986/Creating-Stored-Procedures-in-MySQL-Using-HeidiSQL-4146s-Stored-Routine-Editor.htm
Written by jfalchMoney, Euro
9 months ago
352 posts since Sat, 17 Oct 09
first, please upgrade to heidisql v8.

Then, there is no more icon for the stored routine editor.

To create a stored routine, right-click on the database name in the tree on the left of heidisql, and slect from the context menu "Create new / Stored routine". Enter body, parameters etc on the right, then click "Save" on the bottom.

To edit an existing stored routine, double click it in the tree, or right-click and select "Edit".
Written by Jack_Tauson_Sr
8 months ago
5 posts since Fri, 02 Aug 13
I don't see anything related to subroutine after right clicking. Is there any way to do that?
Written by jfalchMoney, Euro
8 months ago
352 posts since Sat, 17 Oct 09
1) did you upgrade ? i do not know the menu layout for v7.

2) does the context menu for the database contain a "Create new" entry with a submenu ?
Written by Jack_Tauson_Sr
8 months ago
5 posts since Fri, 02 Aug 13
1) I can't upgrade that as I don't have permissions to do that.

2) Please find the image attached
Written by Jack_Tauson_Sr
8 months ago
5 posts since Fri, 02 Aug 13
Written by Jack_Tauson_Sr
8 months ago
5 posts since Fri, 02 Aug 13
Here is the URL to my Image:

https://www.dropbox.com/s/wozl4g1ktt6wgy2/11.jpg
Written by jfalchMoney, Euro
8 months ago
352 posts since Sat, 17 Oct 09
there is a menu entry "Create new". What happens when you click that ? is there a submenu entry "Stored routine" ?
Written by jfalchMoney, Euro
8 months ago
352 posts since Sat, 17 Oct 09
if so, what happens if you select that ?
 

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