when i try to insert multiple rows using the SPUFI am getting some error ',' not valid symbol or something.
say i insert like this
insert into t1 (a,b,c,d) values (1,2,3,4), (5,6,7,8);
I also tried
insert into t1 (a,b,c,d) values ((1,2,3,4), (5,6,7,8));
insert into t1 (a,b,c,d) for 2 rows values (1,2,3,4), (5,6,7,8);
(Here it gave 2 as some error)
So is there any way to insert multiple rows with insert in SPUFI?
In embedded SQL i think this is possible easily...!!!
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
Does this apply?
Quote:
INSERT
There are two forms of this statement:
.. The INSERT via VALUES is used to insert a single row into the table or view using the values provided or referenced.
.. The INSERT via SELECT is used to insert one or more rows into the table or view using values from other tables, or views, or both.