Page 1 of 1

ODBC Driver

Posted: Tue Jan 25, 2011 2:28 pm
by capitanui
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!

Re: ODBC Driver

Posted: Wed Jan 26, 2011 3:44 pm
by admin
Dear Sir,
currently this is not possible. To insert two values is necessary to make a query with INSERT and then with UPDATE. The end result is the same.

Re: ODBC Driver

Posted: Wed Jan 26, 2011 4:16 pm
by capitanui
admin wrote:Dear Sir,
currently this is not possible. To insert two values is necessary to make a query with INSERT and then with UPDATE. The end result is the same.
Thanks..i already did as you said!

Re: ODBC Driver

Posted: Mon Oct 24, 2011 6:52 am
by Lesan
First, sorry for my bad english. :oops:

I want read single gate value, i wrote: SELECT ident FROM w_sledljivost_osnovni_podatki_sedeza WHERE sedez_id=3500000. But i want value sedez_id insert from text box on template? Text box contains another gate.

Re: ODBC Driver

Posted: Wed Oct 26, 2011 10:03 am
by admin
Dear Sir,
I think I understand what you need. Try this demo with its database.

download/Demo_Select_ODBC.zip
download/test.sql

Best Regards

Re: ODBC Driver

Posted: Wed Oct 26, 2011 3:08 pm
by Lesan
Thank you very much, it works.

I only have one more question. How do I restart automatically on failure of the ODBC connection?

Re: ODBC Driver

Posted: Thu Oct 27, 2011 8:19 am
by admin
Hi,
we solved this problem in the new version of Winlog. Download the new version from http://www.sielcosistemi.com

Best Regard