I'm looking for the right script to use a gui input box as a way to rename my SQL table. I have a named query already set to update the database upon a certain parameter string, as I used to do this manually with a text box and button. How can I grab the text entered into this field? The key is I only want to use that text if the "OK" button is clicked, so I need a conditional way to grab the user defined text string.
If I remember correctly from my reading, renaming DB tables is a REALLY bad idea. Why would you want to do that?
Can you use a table with a field to store the Process Name, with associated data in other fields?
The entered value becomes the return value. If cancel is clicked, None is returned.
1 Like
Named Query is not updating the MySQL table. It’s updating a cell in a MySQL table which stores all the various recipes I query.
Need to pull text from that input box and reassign a name from that
How do I reference the buttons to update the line below?
Even.source.text = SQLupdatetext
Show us as much of your script as you can, because it's really hard to explain the right thing to do if we're not sure what you've actually done.
Capturing the input (if the user didn't cancel) of an input box is literally the example on the UM page: