View Incident Report

Serious

Reported By: Guenter Angerer
Reported On: 4/29/2002
For: Version 3.10 Build 1

# 1112 Executing 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

Comments

This 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.

Resolution

Fixed Problem on 8/6/2002 in version 3.13 build 1

More Support Options

Search Incident Reports

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Product Manuals

Roadmap