Using PLC tags as arguments to put in Insert Into SQL Statement

EasyBuilder Pro Q&A
1
  • HMI Model: cMT3126x (V2)
  • EasyBuilder Pro Version: 6.10.02.300

Hello i am having issues with getting arguments to work in my Insert statement for SQL

Insert Into bte_testresults (Description,PartNumber)

Values (‘$(1)’, ‘$(2)’);

Once i setup the Argument to point to the proper PLC tag (String) i am getting a

“Arguments defined and arguments used are not matched”

Argument are setup

Rockwell Ethernet

Program:BrakeTesting.TestingResults.Desc.DATA[0] with a address format SINT(20)

Thank you

2

Hi @mhahn76 ,

Thank you for contributing to our Forum!

Just for our understanding, could you please provide a few screenshots of your project configuration?

Specifically, please include:

  1. The SQL Query object configuration window with your SQL statement.

  2. The Argument tab of the SQL Query object.

  3. And a screenshot of the error code/status value returned by the SQL query.

3

Cant post screenshots, it is telling me embedded images are not allowed

6

Hi @mhahn76,

Thank you again for meeting with me today, I am happy we were able to work out a solution. If you have any additional questions, please feel free to reach out to our forum or our support email.