Question
Peter Monteiro · Aug 2

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]
0
0 96
Discussion (1)1
Log in or sign up to continue