时间: 2021-07-31 作者:daque
即使你有一个创造好的recordset然而你还须要另一个recordset大概两者之间只差一个前提,这功夫咱们就不要创造两个recordset了咱们只须要运用filter 属性就不妨实行这个手段dim objrs, objfilter ' as adodb.recordset dim dcndb ' as adodb.connection set dcndb = server.createobject("adodb.connection") dcndb.open "some connection string" set objrs = server.createobject("adodb.recordset") objrs.open "select * from tblorders", dcndb, adopenstatic objrs.filter = "customername like %smith%" set objfilter = objrs