Question
Standard Chartered Bank
IN
Last activity: 20 Aug 2021 15:31 EDT
RDB-SAVE
Hi All,
Is it possible to insert multiple records into DB using RDB-SAVE at a time.
I tried doing it but i'm getting error.
Used query :-
insert into tablename values ('1','A')
insert into tablename values ('2','B')
insert into tablename values ('3','C')
Regards,
Bharath.
Accepted Solution
Updated: 21 Jun 2021 13:05 EDT
Maantic
IN
@BharathKambavalasa - You can use the statement as below
insert into {Class: <<classname>>} values ({<<Pagename>>.<<Property1>>} ,{<<Pagename>>.<<Property2>>} )
Maantic
IN
@BharathKambavalasa - It is not possible to insert multiple rows using RDB-Save. However you can call the RDB-Save in a loop to insert multiple rows into the table. You can pass the values dynamically into the insert statement in the loop..
Updated: 21 Jun 2021 13:05 EDT
Standard Chartered Bank
IN
@KALINGAROUT -- Thanks for your information. Could you please help me with the above example, that how can we pass the values dynamically to the insert statement.
Accepted Solution
Updated: 21 Jun 2021 13:05 EDT
Maantic
IN
@BharathKambavalasa - You can use the statement as below
insert into {Class: <<classname>>} values ({<<Pagename>>.<<Property1>>} ,{<<Pagename>>.<<Property2>>} )