Update Query with return Value (Output)

getKey=1 as an argument should work for all the flavors of system.db.runUpdate/Prep/NamedQuery as long as your key is just a integer - I saw there was issues if your key is like an UUID.

You would just do newId = system.db.runPrepUpdate("INSERT INTO Control (Name) VALUES (?)", [variableWithValue], geyKey=1)

4 Likes