SQL Error 42s22

Try SQLErrMsg function for detailed error.

The detailed error is "Invalid column name 'String data' ",
it works fine with numeric variables after using, IntToStr function

Hi,

Are you adding single quotes to the string ? Looks like the database thinks you are passing a column alias.
You could try using SQLSet in conjunction with SQLParamsSetAsString .

Error explain you are making some mistake in making string.

The SQLSet function in this case is accepting string data into database, when it is given directly in the command.

The error happens only when I try to import data from "String Variable data" into the database.

If you share your query then it will be very helpful for all of us to help you.

Following is the parts of the  cicode

  STRING st1=IntToStr(VAR1);

  STRING st2=IntToStr(VAR2);    

  STRING st3=IntToStr(VAR3)

{

SQL Connection Block

}

     SQLSet(hSQL, "INSERT INTO TABLE1 (Tag1,tag2,tag3,tag4)VALUES(");

     SQLAppend(hSQL, st1+","+st2+","+st3+",'Test string')"); 

{

Code for error message,

code for SQl disconnection

}

This code works perfect!

Now I need to update the tag4 data in the database with a string variable. I tried using the same format in the VALUES "+VAR4+" , but it returned 42s22 error.

Also i tried with assigning it to a string variable 'st4' and tried loading to the database using "+st4+", even this returned the same error, 42s22 Invalid column name.

Thanks

Bhadresh.

Use SQL query as below:

SQLSet(hSQL, "INSERT INTO TABLE1 (Tag1,tag2,tag3,tag4)VALUES('");
SQLAppend(hSQL, st1+"','"+st2+"','"+st3+"','Test string')");

you were missing single quote(') for each value as per SQL statement.

Try this and let us know.

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+")");