Is it possible to perform multiple inserts or updates in the Query Database?
I understand that the method using recordTyoe and relation is recommended by Appian, but I am asking this question to achieve exclusive control of updates to multiple tables.
I know that this can be accomplished by a procedure, but I would like to know if QueryDatabase can be used as another technique.
Discussion posts and replies are publicly visible
"Multiple" means inserting a RecordType with multiple records.
You can. But just like you mentioned, you shouldn't. But yes, technically, you can!
What exactly do you mean with "achieve exclusive control of updates to multiple tables"? Appian records allow you to only update specific fields.
This is an image of updating multiple tables.When updating a parent table and its associated child tables, I am considering a use case where record locking must be performed to prevent other transactions from accessing the parent table until this series of insert operations is completed.
Locking is a different matter. I would strongly recommend you look at this:
community.appian.com/.../pessimistic-locking
...although having just re-read your note...you don't need to lock a table if you're only performing inserts as there's no risk of one transaction interfering with another...unless you're generating the keys (rather than the database managing this for you)
Thank you very much. I will check it out.