Recommended Posts

Hello, everybody.

I am currently working on a production data record in a database (SQL Server), however, there is an error in the command "db.Execute()" in the sequence shown in the attached image.
How can I solve the error ?

NOTE: I work with: DAQFactory 16.2 , SQL Server 2014 

errorHY010.JPG

Share this post


Link to post
Share on other sites

Your construction of the SQL string is wrong.  You need to use + to create the string:

db.execute(dbase, "INSERT INTO HAR5.dbo.OEMH5(ContadorTotal) VALUES (" + conteo_salida[0] + ")")

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now