Object IDE

Menu: View / Object IDE


Switches the view to an integrated development environment for Views, Stored Procedures, Stored Functions, Triggers and Events.


The Object IDE allows to edit the source for Procedure and Function / the execute statement for Views, Triggers and Events easily. You can edit the code like know from a normal text editor.

To update the changes one click to the toolbar is needed only. This will remove the previous existing object and creating a new one if the MySQL database does not allow a changing of the existing one.

For the case a creating of the updated source is not possible (because of invalid changes) the previous existing object will be re-created automatically.


To test a Procedure / Function you have a line with the input parameters below the source code area. For each parameter an input field is given - related to the field type definition of the source code. The result of the function executing and the output values of the INOUT and OUT parameters will be shown as a result set at the bottom of the Object IDE.

For Procedures with multiple result sets a tab for each single result set will be shown.


To test a Trigger below the source code area there is one single row of the table fields values. You can enter values to use one button for the main trigger events: INSERT, REPLACE, UPDATE and DELETE. Since a Trigger cannot show an output (wether a result set nor parameters) you have to check the working of the trigger by yourself with the SQL Editor or Data Browser. Please don't forget to update the view of it after executing the trigger.


To test an Event SQL-Front stores the statement of the Event in a Stored Procedure temporary, executes this Procedure and remove it again. Like the triggers also an Event doesn't have an output.