Stored Procedures 2

💬 App Building
1

From what I can gather about Stored Procedures, these cannot be run from within Retool. The option is to build the Stored Procedure in the Database then call it from Retool.

I am using MySql Workbench to debug my Stored Procedure but I am finding the debug process very difficult.

I have all the debug notations cleared and I have established a pretty good connection to the Database but the code will not run.

I am using CPANEL for my Database Management.

Are their other tools besides MySql Workbench for debugging Stored Procedures?

Mike

3

I am replying to my own question.

After a lot of trial and error, I have been able to get stored procedures to work very well in Retool without using any 3rd Party software.

There are certain formats for running Do Loops with IF, ELSE, ENDIF statements (nested or not nested) or IF, ELSEIF, ELSE, END IF Statements (often called CASE statements).

The debugging is not good. If you need some sample code to help you get started, I would be pleased to assist.

Mike

4

Thanks for providing an update, @mdsmith1! I've been wanting to create a topic in our Tips & Tricks category that outlines different use cases for stored procedures. I'll let you know once I've published it!

5

Thank you Darren:

I found the learning curve for Stored Procedures very steep.

Real Life working examples would have helped me a lot.

I am happy to share these with others.

Mike

1 Like