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 |
||