SQL in modules Jon (LabKey DevOps)  2015-04-24 16:48
Status: Closed
 
Hi Bront,

I've provided the answers below your original questions:

Question 1. Is it possible to return a value (e.g., the newly inserted rowid) from a Table.insert()?

Answer: According to our developers, yes it can be done. The value is automatically pushed into the object that is returned from Table.insert().

Question 2. Also, is it possible to map an insert()/update() to target multiple tables?

Answer: Not in this case. You would have to make separate calls for each table you want to insert/update or create your own custom SQL code via JDBC connection to pull this off.

Regards,

Jon