当然不能用ado控件来写sql语句来删除,定义一个dim conn as new adodb.connection conn.open connectionStr conn.execute "delete ..."不就可以了
dim cmd as new adodb.command dim conn as new adodb.connection'conn是对数据库的连接 set cmd.activeconnection = conn cmd.commadntype = adcmdtext cmd.commandtext = "你的sql指令" cmd.execute
conn.open connectionStr conn.execute "delete ..."不就可以了
dim conn as new adodb.connection'conn是对数据库的连接
set cmd.activeconnection = conn
cmd.commadntype = adcmdtext
cmd.commandtext = "你的sql指令"
cmd.execute