Hi!
Is it possible to send more than one sql statement by the web component to mysql?
I ask this because I created 3 web components to send three sql statements, however, it only goes one at a time, that is, to send I must click the SEND button three times.
How can I do this so that the 3 web components are called in the same button click?
See, i am using the same code for adding values from app to gsheet (upon certain condition)… But see your logic, your first query seems to be insert, (certainly this will work) but second query you are trying to select something it seems… and again in third query you are trying to insert …
so better you can use clock component for waiting couple of seconds… so it may work feasibly
Already i saidm the above code is to run altogather…
Are you looking to do different functions with same buttons click?
What’s the purpose: I have two tables: the tb_cadastro table records the user’s information minus their access password in the app. The access password in the app I record in the tb_login table where I have a foreign key pointing to the PK of the registration table. So when a new user creates his login, the app records his password in tb_login and the other data in the tb_cadastro table.
I hope the same thing only was suggested using single web block in earlier post but 2nd query was not returned the expected val it seems and his platform expected to be few sec interval so advised him to test with clock and it was worked…
User wants to execute it continuously it seems so…