ASA触发器问题：http://expert.csdn.net/Expert/topic/1965/1965104.xml?temp=.9054376

[am2000]

将SQL SERVER 2000数据库转换为ASA7时碰到如下问题.
SQLSTATE = S0002
[Sybase][ODBC Driver][Adaptive Server Anywhere]Table or view not found: Table 'new_project_plan' not found

No changes made to database.

INSERT INTO "project_plan" ( "projectcode", "plancode", "plandate", "filecode", "buildcontect", "budgefilecode", "budgemoney", "budgedate", "payoutflag", "fundsourcecode", "planmoney", "planbalance", "OperCode", "CheckFlag", "remark", "unitcode" ) VALUES ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )

--触发器源码

alter trigger DBA.plan_insert before insert order 1 on
DBA.project_plan
referencing new as new_project_plan
for each row
//[ WHEN( search_condition ) ]
//插入触发器：更新预算资金余额
begin
declare @budgemoney_inserted numeric(12,2);
declare @projectcode char(12);
declare @plancode char(8);
declare @planbalance numeric(12,2);
set @projectcode=(select projectcode from new_project_plan);
set @plancode=(select plancode from new_project_plan);
set @budgemoney_inserted=(select budgemoney from new_project_plan);
set @planbalance=(select planbalance from new_project_plan);
set @payoutflag=(select payoutflag from new_project_plan);
update project_plan set planbalance = IsNull(@planbalance,0.0)+@budgemoney_inserted where projectcode = @projectcode and plancode = @plancode
end

[leeyoong]

sql server 好象不支持前触发的！

[tchatcha]

new_project_plan对象不存在，是什么，写清楚点