Query based insertion or updating of blob values
The CTE result set is derived from a simple query and is referenced by UPDATE statement.
All other references to the object in the FROM clause must include an object alias. If i want to fill Data over Parameter in a Textblob-field, i have this error: BLOB and array data types are not supported for move operation I use Delphi 7 Prof und IBDAC2. Specifies the temporary named result set or view, also known as common table expression (CTE), defined within the scope of the UPDATE statement.Compound assignment operator: = Add and assign -= Subtract and assign *= Multiply and assign /= Divide and assign %= Modulo and assign &= Bitwise AND and assign ^= Bitwise XOR and assign |= Bitwise OR and assign Returns updated data or expressions based on it as part of the UPDATE operation.The OUTPUT clause is not supported in any DML statements that target remote tables or views.
A view with an INSTEAD OF UPDATE trigger cannot be a target of an UPDATE with a FROM clause.