我用Sql语句得到了RecordSet:
Dim rs As Recordset
Set rs=db.OpenRecordSet("SELECT * FROM TableName WHERE 记录名=abc")
请问我该如何删除所有找到的记录,该不会是
While Not(rs.Eof)
rs.Delete
rs.MoveNext
Wend
吧!
如果我想删除一张表,又该怎么写呢?
...全文
1121打赏收藏
删除Recordset数据问题
我用Sql语句得到了RecordSet: Dim rs As Recordset Set rs=db.OpenRecordSet("SELECT * FROM TableName WHERE 记录名=abc") 请问我该如何删除所有找到的记录,该不会是 While Not(rs.Eof) rs.Delete rs.MoveNext Wend 吧! 如果我想删除一张表,又该怎么写呢?