The insert failed because a column definition includes validation
constraints.
validation error for column ISREADONLY, value "*** null ***".
At trigger 'E_VT003' line: 59, col: 3
At trigger 'I_VT003_9' line: 34, col: 5.
ÎÁÞÁÌ ÒÙÔØ É ÎÁÒÙÌ
× ÔÒÉÇÇÅÒÅ I_VT003_9
ÐÒÉ ×ÙÐÏÌÎÅÎÉÉ ÓÔÒÏË
update VT003 set D024_1 = NEW.D024_1
where VT003.T003_1 = NEW.T003_1;
ÐÏÌÕÞÁÅÍ ÏÛÉÂËÕ ÎÏ ÍÙ ÖÅ ÐÏÌÅ ÎÅ ÒÅÄÁËÔÉÒÏ×ÁÌÉ
ÄÁ É ÐÏ ÌÏÇÉËÅ ×ÅÝÅÊ
case when (T003.ISReadOnly = 1 or (not T003.T003_10 IS NULL and T003.T003_10
< 'NOW'))
then 1
else 0
end as ISReadOnly
ÐÒÉ ×ÓÅÍ Ó×ÏÅÍ ÖÅÌÁÎÉÉ null ÐÏÚ×ÒÁÝÁÔØ ÎÅ ÄÏÌÖÅÎ
ÒÁÎØÛÅ ÒÁÂÏÔÁÌÏ ÂÅÚ ÐÒÏÂÌÅÍ
http://www.sayan.ru/~bolt/DY/
×ÓÅ ÆÁÊÌÙ ËÏÔÏÒÙÅ ÐÏÎÁÄÏÂÑÔÓÑ
É ÅÝÅ ÍÏÖÎÏ ÜÔÏ ÐÏÐÒÁ×ÉÔØ ÐÏÂÙÓÔÒÅÊ ÓÅÇÏÄÎÑ ÄÕÒÅÎØ ÎÁÔËÎÕÌÓÑ ÎÁ ÍÅÓÑÞÎÙÊ ÂÁÇ
ÓÏÏÂÝÁÌ ÏÂ ÎÅÍ DY ÅÝÅ ÍÅÓÑÃ ÎÁÚÁÄ ÏÔËÁÔÉÌ ÎÁÚÁÄ
ÅÇÏ ÉÓÐÒÁ×ÉÌÉ ÎÏ ×ÓÅ ×ÒÅÍÑ ÂÙÌÉ ËÁËÉÅÔÏ ÚÁÔÙËÉ × ËÁÖÄÏÊ ÓÂÏÒËÅ
Ñ ÓÅÇÏÄÎÑ ÓÌÕÞÁÊÎÏ ÚÁÍÅÔÉÌ ÞÔÏ Õ ÍÅÎÑ ËÕÞÁ ËÏÄÁ ÂÙÌÁ ÐÅÒÅÐÉÓÁÎÁ ÎÁ
returning d009_1 into new.d009_1;
×ÏÔ ÚÁÓÁÄÁ Á Ñ ÀÚÅÒÏ× ÎÁÆÉÇ ÐÏÓÙÌÁÌ ÄÕÍÁÌ ÞÔÏ ÔÏÌØËÏ × 3 ÍÅÓÔÁÈ ÉÓÐÏÌØÚÏ×ÁÌ
ÔÁÍ ÚÁÔÙÞËÉ ÎÁÐÉÓÁÌ ÚÁÎÏ×Ï, Á ÓÁÍ ÓÔÏËÁ ÐÅÒÅÌÏÐÁÔÉÌ ÞÔÏ ÓÁÍ ÕÄÉ×ÌÑÀÓØ ËÁË
ÐÒÏ ÜÔÏ ÚÁÂÙÌ. ñ ÏÔËÁÔÉÌ ÜÔÏ ÎÏ ÔÁÍ ÌÏÇÉËÁ ÎÁ returning ÂÙÌÁ ÚÁÔÏÞÉÎÁ. âÌÉ
ÂÌÉÎ ...
