INSERT INTO with multiple rows without Select?


New Member
I just got this error:
java.sql.SQLException: [DataDirect][OpenEdge JDBC Driver][OpenEdge] Syntax error in SQL statement at or about ", ("A", "B"
Normaly in SQL you can do INSERT INTO (columns_list) VALUES (values for row1), (values for row2) ...
I looked up the docs and theres the possiblity to insert rows from a subselect or something.

Is there no way to just put 2 rows with one statement?



Well-Known Member
Are you intentionally pointing to a Data Direct driver page?

The 'regular' documentation at Progress Documentation has:
The VALUES (...) form for specifying the column values inserts one row into the table. The query expression form inserts all the rows from the query results.
So it would seem you are out of luck. You could question how SQL92 compliant this really is.