declare p_cur cursor for
select column... from table..
where column...=:temp
using sql_old;
open p_cur;
fetch p_cur into :temp.....;
do while sql_old.sqlcode = 0
update (或进行其他操作) table..
set column..=:temp......
where column..=:temp.... using sql_new;
if sql_new.sqlcode < 0 then return -1
fetch p_cur into :temp.......;
loop
close p_cur1;
transaction yourdatabase
yourdatabase=create transaction
//---------
yourdatabase.DBMS = "MSS Microsoft SQL Server 6.x"
yourdatabase.servername="servername"
yourdatabase.Database="yourdatabasename"
yourdatabase.logid="sa or you password"
remote_database.autocommit=false
remote_database.DBParm = "secure=0"//如果是98就用1如果是nt或2000就用0
connect using yourdatabase;
//----------------------------
你要写的程序
//------------------------------
commit using yourdatabase;
disconnect using yourdatabase;
destroy yourdatabase;
connect using sqlca;
if sqlca.sqlcode <> 0 then
MessageBox ("Cannot Connect to Database", zdb_sqlca.sqlerrtext)
return
end if
//第二个连接
SQLCA_2=create transaction
SQLCA_2.DBMS = "ODBC"
SQLCA_2.AutoCommit = false
SQLCA_2.DBParm = "Connectstring='DSN=data2;UID=dba;PWD=sql'"
connect using zdb_sqlca;
if sqlca2.sqlcode <> 0 then
MessageBox ("Cannot Connect to Database", zdb_sqlca.sqlerrtext)
return
end if