没什么特殊格式.
Select,Update,Insert,Delete都行,只是在使用时Select要用如下形式:dim rs as adodb.recordset
dim conn as adodb.connection
.....
set rs=conn.execute("select * from tablename")
因为Select要返回结果,其它的就直接
conn.execute "delete from tablename"
就行了.
Select,Update,Insert,Delete都行,只是在使用时Select要用如下形式:dim rs as adodb.recordset
dim conn as adodb.connection
.....
set rs=conn.execute("select * from tablename")
因为Select要返回结果,其它的就直接
conn.execute "delete from tablename"
就行了.
adoConnection.Execute ("insert into search(id,webname,weburl) values("",netname(i).text,netaddress(i).text)")
adoConnection.Execute "insert into search(id,webname,weburl) values('',netname
(i).text,netaddress(i).text)"
values("",netname(i).text...中的""要改为''。