Skip to main content
T
tomoo7550
June 13, 2023
Solved

Is it possible to perform multiple inserts or updates in the Query Database?

  • June 13, 2023
  • 7 replies
  • 1 view

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.

Best answer by harshitb6843

You can. But just like you mentioned, you shouldn't. But yes, technically, you can!

7 replies

T
tomoo7550Author
June 13, 2023

"Multiple" means inserting a RecordType with multiple records.

harshitb6843
harshitb6843Answer
June 13, 2023

You can. But just like you mentioned, you shouldn't. But yes, technically, you can!

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    June 13, 2023

    What exactly do you mean with "achieve exclusive control of updates to multiple tables"? Appian records allow you to only update specific fields.

      T
      tomoo7550Author
      June 13, 2023

      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.

      stewart.burchell
      stewart.burchell
      June 13, 2023

      Locking is a different matter. I would strongly recommend you look at this:

      community.appian.com/.../pessimistic-locking

        Terms & ConditionsAccessibility statement