请大家看看我写ASA数据库的触发器有什莫毛病?
alter trigger dba.gl_trigger after update order 1 on
DBA.tbl_boiler_sub
referencing old as before_update new as after_update
for each row
begin//问题是,为什莫程序不能进入下面if条件中,gsdealtype字段是Vachar型的,
//其值也确实发生了变化,可就是不能弹出ok的提示框,是不是ASA触发器语
//法规定比较两个字符型变量的符号不能是=或<>这些?
if after_update.gsdealtype <> before_update.gsdealtype then
raiserror 30001 'ok';
end if;
end