请大家帮助看一下!
SQLCA.DBMS = "MSS Microsoft SQL Server 6.x"
SQLCA.Database = ...
SQLCA.LogPass = ...
SQLCA.ServerName =...
SQLCA.LogId = ...
SQLCA.AutoCommit = False
SQLCA.DBParm = ""
connect using sqlca;
transaction SQLCA1
SQLCA1=create transaction
SQLCA1.DBMS = "O84 Oracle8/8i (8.x.4+)"
SQLCA1.LogPass = ...
SQLCA1.ServerName = ...
SQLCA1.LogId = ...
SQLCA1.AutoCommit = False
SQLCA1.DBParm = ""
connect using sqlca1;
if sqlCA1.sqlcode<>0 or sqlca.sqlcode<>0 then
messagebox("错误",sqlca.sqlerrtext,exclamation!)
halt close
else
open(w_1)
end if
select count(*) into :num from user using sqlca1;
update dbo.table1 set se=:num where id="1" using sqlca;
commit;
我想把oracle的统计结果保存到sqlserver中,可是select语句报错说:对象名user无效,请帮助看一下是什么原因,谢谢!