Database Connectivity Toolkit (multi row insert)

[pincpanter]

Just a guess: are you sure you can use comma as decimal separator?

[aputman]

Now that you have no quotes on the float, your issue is probably the comma as a decimal separator.  

[Emidpont]

I had the same error even before adding the channels table when I was trying to insert just the values ( My query was : insert into mesure (valeur) values(%f); ) .

[aputman]

Right.  And if you have a comma separator, your query looks like it has two input parameters.  

Insert into mesure (valeur) values (13,935527);

13 is one input parameter.

935527 is another input parameter.

That's why the period is the superior decimal separator.  

[pincpanter]

Obviously. And won't you try using a period as decimal separator?

Just prepend %.; to your format string.

[Emidpont]

I tried that, no difference except that I have the error with a period now instead of a comma

[pincpanter]

It seems that your query ends with the substring "insert i": where does it come from?

[Emidpont]

I think it's just due the error message (window too small for the whole message) and it has nothing to do with the query. My query is just as shown in the string constant.

[aputman]

Look in your ODBC connection settings.  You may have to enable multiple statement queries.  Otherwise, anything after the first semicolon is a syntax error.  

[aputman]

Here: