如何执行sql语句？

[wobensuren]

我用一个dw显示一个表的数据t1(id,name)
我想用一个sql语句delete * from t1 where (t1.id in (select id from t2))
用什么语句和命令？ 我用了dw_1.setsqlpreview()
一点作用也没有

[minilin_11]

String ls_SQL

dw_1.setTransObject(SQLCA)
ls_SQL = "delete * from t1 where (t1.id in (select id from t2))"
dw_1.setSqlSelect(ls_sql)
dw_1.retrieve()

[xlhl]

delete from t1 where (t1.id in (select id from t2));
commit;
直接在脚本中执行

[myclife]

EXECUTE IMMEDIATE SQLStatement
{USING TransactionObject} ;

[minilin_11]

先将这个SQL语句赋给一个字符串变量，然后用SetSqlSelect()函数将这个SQL语句赋给数据窗口，然后retrieve就可以了

[wobensuren]

myclife(反方向的钟--忏悔中)
我是新手，请详细点呀

[booksfount]

还可把脚本直接写在dw中，convert to syntax ,then write

[myclife]

String ls_SQL

ls_SQL = "delete * from t1 where (t1.id in (select id from t2))"

EXECUTE IMMEDIATE :ls_SQL Using sqlca;

If sqlca.SQLCode = 0 Then
COMMIT;
Else
Rollback;
End If