Firebird-2.1.0.15972-0_win32 ÐÒÏÂÌÅÍÁ ÔÁÖÅ :(
"Boltik Evgeny" <[EMAIL PROTECTED]>
ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:[EMAIL PROTECTED]
>
> ÎÕ ÄÕÍÁÀ ÇÌÑÎÕ ÄÁÌØÛÅ ÛÔÏ ÒÁÂÏÔÁÅÔ ÎÅ ÒÁÂÏÔÁÅÔ É ÏÐÁ ÏËÁÚÙ×ÁÅÔÓÑ ÐÒÏÇÁ
> ×ÏÏÂÝÅ ÓÔÁÌÁ ÐÒÁËÔÉÞÅÓËÉ ÎÅÒÁÂÏÞÅÊ Ô.Ë.
> × ÔÒÉÇÇÅÒÅ E_V013 ÎÁÐÉÓÁÎÏ
> SELECT T003.ISReadOnly, T003.T003_2_1, T003.T003_2_2,
> (SELECT D009_9 FROM D009 S WHERE S.D009_1 = T003.D009_1) as D009_9
> FROM VT003 T003
> WHERE T003.T003_1 = NEW.T003_1
> INTO ISReadOnly, VT003_2_1, VT003_2_2, VD009_9;
> if (ISReadOnly is null) then
> if (b_msgdlg('null')=0) then begin end
> É ×Ï ÌÑ ÐÏÌÕÞÁÅÍ ISReadOnly = null
> ÜÏÔÑ ÐÏ ÏÐÒÅÄÅÌÅÎÉÀ null ÂÙÔØ ÎÅ ÍÏÖÅÔ ×ÏÔ ÔÁËÉÅ ÐÉÒÏÇÉ ËÏÒÏÞÅ ÞÔÏ ÔÏ
> ÏÔ×ÁÌÉÌÏÓØ × ËÁÌØË ÐÏÌÑÈ ÐÒÉÞÅÍ × ÔÒÉÇÇÅÒÁÈ
>
> ×ÙÚÏ×
> SELECT T003.ISReadOnly
> FROM VT003 T003
> ×Ù×ÏÄÉÔ ÚÎÁÞÅÎÉÑ
> Á ×ÙÚÏ×
> SELECT T003.ISReadOnly,
> (SELECT D009_9 FROM D009 S WHERE S.D009_1 = T003.D009_1) as D009_9
> FROM VT003 T003
> × ÐÏÌÅ ISReadOnly ×ÏÚ×ÒÁÝÁÅÔ null
>
>
> "Boltik Evgeny" <[EMAIL PROTECTED]>
> ÓÏÏÂÝÉÌ/ÓÏÏÂÝÉÌÁ × ÎÏ×ÏÓÔÑÈ ÓÌÅÄÕÀÝÅÅ: news:[EMAIL PROTECTED]
>>
>> 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
>> ÂÙÌÁ ÚÁÔÏÞÉÎÁ. âÌÉ ÂÌÉÎ ...
>>
>>
>>
>
>
>
>