ODBC Driver
Posted: Tue Jan 25, 2011 2:28 pm
Can i write multiple values to a database with a single query?
I have a table
id | value1 | value2
| |
| |
I defined 2 gates with address QUERY_1,QUERY_1 for writing
On ODBC driver configuration at Write SQL Queries at QUERY_1 i wrote : INSERT INTO <table> (value1, value2) values (%4.2lf, %4.2lf) or INSERT INTO <table> (value1, value2) values (%g, %g)
It writes only in the first column, at first query the first value, second query the second value! I also tried to group the gates in a block but for nothing...
Is ther any solution for this issue?
Thanks in advance!
I have a table
id | value1 | value2
| |
| |
I defined 2 gates with address QUERY_1,QUERY_1 for writing
On ODBC driver configuration at Write SQL Queries at QUERY_1 i wrote : INSERT INTO <table> (value1, value2) values (%4.2lf, %4.2lf) or INSERT INTO <table> (value1, value2) values (%g, %g)
It writes only in the first column, at first query the first value, second query the second value! I also tried to group the gates in a block but for nothing...
Is ther any solution for this issue?
Thanks in advance!