| Subject | Re: Major stumbling block: Lack of multiple-row insert capability |
|---|---|
| Author | jrmrenegade |
| Post date | 2007-01-23T17:13:13Z |
Hi Ivan,
Are you saying that I can send as one string: "EXECUTE BLOCK AS BEGIN
INSERT INTO TABLE1(col1,col2) VALUES(1,2); INSERT INTO
TABLE1(col1,col2) VALUES(3,4); END" and it will work? That's what I
mean by "batch". I'm talking about sending all the commands at once,
which is functionally equivalent to multi-row insert statements (not
as fast, but perhaps tolerable).
Are you saying that I can send as one string: "EXECUTE BLOCK AS BEGIN
INSERT INTO TABLE1(col1,col2) VALUES(1,2); INSERT INTO
TABLE1(col1,col2) VALUES(3,4); END" and it will work? That's what I
mean by "batch". I'm talking about sending all the commands at once,
which is functionally equivalent to multi-row insert statements (not
as fast, but perhaps tolerable).