Use of "INSERT INTO" to update a table via SQL query: /home/Support/LabKey Support Forum

Use of "INSERT INTO" to update a table via SQL query

LabKey Support Forum (Inactive)

View Message

Use of "INSERT INTO" to update a table via SQL query

John K.

2015-01-22 13:54

Status: Closed

It seems that "INSERT INTO" is not recognized in labkey SQL.

I am trying to update one list by adding new rows (and data) from another.

Any alternatives?

Jon (LabKey DevOps) responded:	2015-01-22 14:46
Hi John, You can use the LABKEY.Query.insertRows() API call to insert rows. https://www.labkey.org/download/clientapi_docs/javascript-api/symbols/LABKEY.Query.html#.insertRows Are you trying to insert rows just once or are you trying to insert new rows upon a specific event? Regards, Jon