How to combine several queries into one function?

[tkgreg]

Basically, my question is about an approach. Currently I have a three queries which do these:

1. Create sale entry in DB
2. Create sale item in DB with sale entry id from the first query
3. Update stock table with a new amount for each sale item

I call of these queries one by one from Run Script action of the Button. My question is: can I have a special function which will combine all of these queries or my approach is already good enough?

I'm really new to Retool maybe I'm missing something else.

[tkgreg]

I've decided to use PLSQL functions. Looks like its a proper way to handle all of these queries

[jg80]

It looks like you are trying to insert a parent record, then one or more child records, and then make an update to a third table. I've just seen and responded to a similar-ish question here:

Bulk insert records with foreign key

Hi, I'm trying to insert records in 2 tables 1 records into a parent table 'ecriture', say [ { id : xx , comment : "some comment"} ] with the id being defined when record is inserted. Several records into a children table 'lignes_ecritures', with foreign key to 'ecriture', say [ { id : aa , amount : 33 , ecriture : xx }, { id : bb , amount 44 , ecriture : xx } ] with the ecriture foreign key being the id of inserted 'ecriture' record The records in the children table are stored …

You can certainly write PL/SQL functions in your DB, or you can try something like the linked question as well, triggering each subsequent step from the success of the one before (or in a JS block).