部分源码如下: Public Function GetDataXml() As String Dim tmpStream As New ADODB.Stream Dim strTmp As String Dim tmpRecordSet As New RecordSet tmpStream.Open If GetData() Then If myRecordSet.State = 1 Then myRecordSet.Save tmpStream, adPersistXML strTmp = tmpStream.ReadText End If End If
行不行?
Set dbs = OpenDatabase("Northwind.mdb")
' 在新客户表中选择所有记录,
' 并且添加它们至客户表。
dbs.Execute " INSERT INTO Customers " _
& "SELECT * " _
& "FROM [New Customers];"
dbs.CloseEnd Sub
Public Function GetDataXml() As String
Dim tmpStream As New ADODB.Stream
Dim strTmp As String
Dim tmpRecordSet As New RecordSet
tmpStream.Open
If GetData() Then
If myRecordSet.State = 1 Then
myRecordSet.Save tmpStream, adPersistXML
strTmp = tmpStream.ReadText
End If
End If
tmpStream.Close
GetDataXml = strTmp
End Function
你可以用事务啊,开始事务,然后删纪录,保存成xml,然后再回滚事务
cnn.BeginTrans
rs.filter="id>10"
rs.delete AdAffectGroup
rs.save .......
cnn.RollbackTrans