• Replies 9 replies
  • Subscribers 576 subscribers
  • Views 677 views
  • Users 0 members are here
Options
Related

SQL Error 42s22

Nayana

Hi,

I'm trying to upload variable tag data from citect SCADA.

SQL error 42s22 happens when I try to upload a string data to the database using cicode, SQLSet and SQLAppend, but works fine with integer variables.

Please suggest any solution to this.

Parents
  • Hi.
    You wrote, that the example code works perfect. It writes the string (Test String) to tag4. Do I understand right, that now you want to write the content of str4 to tag4. You didn't tell completely, what you changed. Did you add the closing bracket?
    I think the last line should be:
    SQLAppend(hSQL, st1+","+st2+","+st3+","+st4+")");
Reply
  • Hi.
    You wrote, that the example code works perfect. It writes the string (Test String) to tag4. Do I understand right, that now you want to write the content of str4 to tag4. You didn't tell completely, what you changed. Did you add the closing bracket?
    I think the last line should be:
    SQLAppend(hSQL, st1+","+st2+","+st3+","+st4+")");
Children
No Data