attempted update of read-only column

Vladimir A.Bakhvaloff Fri, 29 Sep 2006 04:02:23 -0700
òÁÔÕÊÔÑ, ÂÒÁÔÃÙ!!!

÷ÏÔ ËÁËÁÑ Ó æâ2.12745 ÒÁÄÏÓÔØ ÓÌÕÞÁÅÔÓÑ...
åÓÔØ ÔÁËÏÊ ÁÐÄÅÊÔÉË:
UPDATE TBL_InDoc
  SET ID_UserLock = 0
  WHERE ID_UserLock = :ID_User
é ÎÁ ÎÅÇÏ ÜÔÏÔ æâ2.12745 ÇÒÑÚÎÏ ÒÕÇÁÅÔÓÑ, ÞÔÏ: This column cannot be updated 
because it is derived from an SQL function or expression. attempted update 
of read-only column.
...
ðÏÞÉÔÁÌ ÍÕÄÒÙÊ ÆÁÊÌÉË README.incompatibilities.txt...
íÎÏÇÏ ÄÕÍÁÌ ÐÒÏ:
  * Assignments to OLD contexts are now prohibited for all kinds of 
triggers.
    Also, assignments to NEW contexts in AFTER-triggers are prohibited as 
well.
    So, if you get an unexpected error "cannot update a read-only column", 
this
    is exactly the reason.
...
ðÏÓÍÏÔÒÅÌ ÎÁ ÔÒÉÇÇÅÒ, ÐÒÁ×ÄÁ, ÎÁ BEFORE UPDATE:
  IF (OLD.ID_UserLock <> NEW.ID_UserLock and NEW.ID_UserLock <> 0 and 
OLD.ID_UserLock <> 0) THEN
    EXCEPTION EXC_DocumentIsLocked;
  ELSE
    NEW.DateLastEdit='NOW';
÷ AFTER UPDATE - ×ÏÏÂÝÅ ÎÉÞÅÇÏ ËÒÉÍÉÎÁÌØÎÏÇÏ... :\
ëÏÒÏÞÅ, ÎÉ ÆÉÇÁ ÎÅ ÐÏÎÑÌ... :/
...
ïÄÎÁËÏ, ÐÏÄÕÍÁ× ÐÏÌÞÁÓÁ, Ñ ×ÓÐÏÍÎÉÌ, ÞÔÏ × ÂÁÚÅ 8 (×ÏÓÅÍØ)ÔÁÂÌÉÃ ÔÁËÏÇÏ 
ÔÉÐÁ... é ÔÒÉÇÇÅÒÁ Õ ÎÉÈ ÉÄÅÎÔÉÞÎÙÅ... ôÏÌØËÏ ×ÏÔ ÜÔÏÔ NEW.DateLastEdit É 
ÍÅÎÑÅÔÓÑ...
á ÏÛÉÂËÕ-ÔÏ ×ÙÄÁ£Ô ÔÏÌØËÏ ÎÁ Ä×ÕÈ ÔÁÂÌÉÃÁÈ!.. 8-ï
þÔÏ ÂÙ ÜÔÏ ÍÏÇÌÏ ÂÙÔØ ÔÁËÏÅ É ËÁË Ó ÎÉÍ ÂÏÒÏÔØÓÑ?..
attempted update of read-only column

Ответить
