Hello ,

the "insert into" statment on my ms access 2007 don't accept multiple values:
- INSERT INTO tab (campo1,campo2) VALUES (valore1, valore2)
works fine, but ..
- INSERT INTO tab (campo1,campo2) VALUES (valore1, valore2),(valoreb1,valoreb2)
don't work

That is correct. That syntax will only insert ONE record and ONE set of values.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 5/30/2011 5:46 PM, informatix wrote:

MySQL can accept multiple 'rows' in a single INSERT statement (http://
dev.mysql.com/doc/refman/5.5/en/insert.html), but perhaps this is only
on newer versions of the server. What version are you using
Informatix?

The Frog

Then I would guess you would need to use a pass-through query if you are using
an odbc connection.


John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 5/31/2011 4:38 AM, The Frog wrote:

It should be done by db.execute. It could also be done as a
passthrough with a query object. What I have usually found when
constructing multiple row insert statements is that there is often an
extra comma or some such in the constructed SQL. Perhaps Informatix
can place a break point in the code just before the .execute method
and post the SQL that is created for us to have a look at?

If we need to shift it to a query object then that is also not
difficult to do, but unlesss we know that the SQL is properly formed
then it wont matter how we try to send the command to the server it
just wont work.

The Frog