Retool can't find my app

💬 App Building
1

I have a MySQL app called DeleteAppt3 which runs fine.

But now I am calling it from a stored procedure with the code call DeleteAppt3()

This generates an error message that it can't find the app. I have included my database address as call workflow01.DeleteApp3(). This does not help.

I have checked my data base and it shows maybe 20% of my apps in its app list.

Any suggestions?

Mike

4

is DeleteApp3 an app in Retool?

if you’re trying to call it from a MySQL stored procedure, MySQL won’t know anything about named retool apps.

You could either make everything in MySQL (store DeleteApp3 as a procedure), or within your Retool app, make a workflow where it triggers based on whatever schedule you want.

5

jr data
Yes, I have been learning a lot from ChatGPT and it turns it is best to run loops and if statements that have to call programs from Java Script.
Stored procedures need to work with local tables and where the full code can be written in the stored procedure.
I now have everything is working but I appreciate your followup.
I will mark your answer as a solution.
Thank you.
Mike