ASA数据库中的这个触发器为什么会出错?
690cj 2004-12-02 12:51:49 ALTER TRIGGER "up_ceiliang" BEFORE INSERT
ORDER 1 ON sjb
REFERENCING NEW AS new_name
FOR EACH ROW
// [ WHEN( search_condition ) ]
BEGIN
if(select celiang.sheng_yu-new_name.dian_jia*new_name.jin_z from celiang,new_name where celiang.chehao = new_name.che_hao) > 0 then
update celiang set
celiang.sheng_yu = round(celiang.sheng_yu-(new_name.dian_jia*new_name.jin_z),1) where
celiang.chehao = new_name.che_hao
else
update celiang set
celiang.sheng_yu = 0 where celiang.chehao = new_name.che_hao
end if
END
保存时没有问题,当在程序中触发插入事件时出现如下错误。
SQLSTATE = S0002
[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not found: Table 'new_name' not found
No changes made to database.
INSERT INTO "sjb" ( "fyd", "che_hao", "che_xin", "huo_min", "si_ji", "rq", "sj", "mao_z", "pi_z", "jin_z", "czy", "dian_jia", "fukuan_fs", "bufeng_fuku" ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
请高手帮忙。