WI-T6.3.0.12669 Firebird 2.0 Release Candidate 2

execute block
returns (REASON integer)
as
declare variable B integer;
begin
 B = 1;
 REASON = case B
          when 1 then 130
          when 0 then 0
          when null then 131
          end;
 suspend;
 B = 0;
 REASON = case B
          when 1 then 130
          when 0 then 0
          when null then 131
          end;
 suspend;
 B = null;
 REASON = case B
          when 1 then 130
          when 0 then 0
          when null then 131
          end;
 suspend;
end

ÄÁÅÔ:

130
0
null

Ñ ×ÅÒÉÌ, ÞÔÏ ÂÕÄÅÔ
130
0
131

ËÓÔÁ, × ÐÏÌÔÏÒÁÛËÅ
 REASON = case B
          when 1 then 130
          when 0 then 0
          else 131
          end;

×ÙÄÁÅÔ

130
0
131

-- 
âÕÌÙÞÅ× áÌÅËÓÅÊ
http://www.stella-npf.ru 



--~--~---------~--~----~------------~-------~--~----~
-~----------~----~----~----~------~----~------~--~---

Ответить