Adding multiple rows to a projected SQL table - Persistent Object
Hi
I'm trying to add multiple rows at a time to a SQL table for a persistent object, but I can't seem to get the syntax correct. When I try the below it doesn't work.
INSERT INTO Sample_Table.Accounts (Account, AccountName, Bank)
VALUES
('123456', 'AccountNameOne', 'BANK1'),
('654321', 'AccountNameTwo', 'BANK2')
Thanks
Peter
Product version: IRIS 2021.2
$ZV: IRIS for Windows (x86-64) 2021.1.2 (Build 338U) Tue Apr 12 2022 12:04:03 EDT [Health:3.3.0]
INSERT INTO Sample_Table.Accounts (Account, AccountName, Bank)
Select '123456', 'AccountNameOne', 'BANK1' union all
Select '654321', 'AccountNameTwo', 'BANK2'
Details: https://docs.intersystems.com/iris20221/csp/docbook/Doc.View.cls?KEY=RSQL_insert