To update in SQL your query must be like :
UPDATE <tbl_nm>
SET <att_nm1> = ( your attribute name)', <att_nm2> = ( your attribute name)'
FROM <tbl_nm>
WHERE<att_nm3> = '( your attribute name)'
If it is an integer, you dont need the quotes ('). But if your update or where statement is a string, the @Value() must be between quotes.
Then, if your string contains quotes, you must double them ...
example : 'It's cold outside' become 'It'' cold outside'
It look like in your string you dont have the FROM <tbl_nm> even if you specified it in the UPDATE statement.
Good luck!
If it's Oracle you can specify an alternative quote character to avoid collisions with quotes in your attribute values. Here's an example where the quote character is set to #:
... WHERE OTHER_COLUMN_NAME = q'#@VALUE(ATTRIBUTE_2)#'
It's documented here: https://livesql.oracle.com/apex/livesql/file/content_CIREYU9EA54EOKQ7LAMZKRF6P.html
To update in SQL your query must be like :
UPDATE <tbl_nm>
SET <att_nm1> = ( your attribute name)', <att_nm2> = ( your attribute name)'
FROM <tbl_nm>
WHERE<att_nm3> = '( your attribute name)'
If it is an integer, you dont need the quotes ('). But if your update or where statement is a string, the @Value() must be between quotes.
Then, if your string contains quotes, you must double them ...
example : 'It's cold outside' become 'It'' cold outside'
It look like in your string you dont have the FROM <tbl_nm> even if you specified it in the UPDATE statement.
Good luck!
Which SQL variant is this? The regular SQL syntax for updating table contents usually does not include the FROM clause:
UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE condition;
A StringConcatenator can help with creating SQL statements as well.
