Reported By: Guenter Angerer Reported On: 4/29/2002 For: Version 3.10 Build 1
# 1112Executing a Joined SQL UPDATE Statement that Updates a BLOB Field Causes #8708 Record Changed Error If I execute the following SQL, an 8708 error appears, if the filler is CHAR(250) the statement works.
ALTER TABLE '%sct\BASE'
ADD 'FILLER' BLOB(0,1);
UPDATE '%sct\BASE' b
SET b.FILLER = b.FILLER + PAY.PAYMENT_AMOUNT_TYPE
FROM '%sct\BASE' b
INNER JOIN '%sct\PAYMENTS' PAY
ON PAY.COMP = b.COMP
CommentsThis was originally supposed to be fixed in 3.11 but there was an additional bug introduced in 3.12 regarding this type of SQL statement.
ResolutionFixed Problem on 8/6/2002 in version 3.13 build 1