fengmingbao 发表于 2008-10-13 12:48:20

连接数据库时能否执行多条语句?

Set con=createobject("adodb.connection")
conset = "......................................."

con.open conset

Ifcon.state=0 Then
        msgbox"DB Connection Failed"
End If

Set rs=createobject("adodb.recordset")

sql="select * from TicketTbl where TicketI = "&TicketID&" and TicketV = "&TicketVersion&""

这里能否存在多条?如果能,怎么做? 谢谢

sunqiang1024 发表于 2008-10-13 14:18:38

可以的,然后你声明多个结果集应该就行了
页: [1]
查看完整版本: 连接数据库时能否执行多条语句?