ASA7中触发器问题！！！！！

[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

[mengfan8868]

检测触发器是否已经加到ASA数据库中了

[am2000]

??我就是在ASA中进行编辑的啊.还要另外加入吗?

[sinkiangscorpio]

declare @budgemoney_inserted numeric(12,2);
declare @projectcode char(12);
declare @plancode char(8);
declare @planbalance numeric(12,2);
在asa当中定义变量是这么写得吗，我也记不清楚了

[dotnba]

水兄的问题我只能UP了
我对ASA不熟悉
您上SQL版看看，那边数据库高手不少，比如大力

[pbcoder]

不懂，只能帮你up了。

[jeff_107]

学习！

[andyzq]

我对ASA也不熟悉，你去其他板块问问

[tchatcha]

set @projectcode=(select projectcode from new_project_plan);

这样语句改为
select @projectcode=(select projectcode from new_project_plan);


用pb8连接asa的网络版数据库,完全可以，用dbsrv8.exe启动服务

[fbc]

问题解决了。吗
提示的内容显示。你打开表或者视图没有建立。或者建立的有问题。
我可以问一个问题吗。
你用的是asa的网络数据库吗。
我想用pb8连接asa的网络版数据库，应该怎么做呢。

[am2000]

我基本解决了.
我是看到ASA支持两种语法，所以想直接从SQL SERVER转化为ASA.不是很成功。

[am2000]

to tchatcha(老刀):请问哪里有ASA8下载的？另外，ASA7中怎么去掉查看数据时的那个双引号

[am2000]

SQLSTATE = 08001
[Sybase][ODBC Driver][Adaptive Server Anywhere]Unable to connect to database server: Authentication violation