testing if the field is null

[lodvini]

Select all

 
if not( :G.ARTIGO IS NOT NULL ) then 
  message( 'Erro - '||:system.trigger_field ); 
  message(' '); 
  clear_message; 
  raise erro; 
end if; 

Why not just test "IF Field IS NULL" ???

[dr_gori]

In algebra, this is known as "double denial"
something like this:
~~ p <=> p
"no p is equivalent AP "
: D

[NaPraia]

Why not just test "IF field is null" ???

That is so easy, clear and clean.