Up until now I've been setting my CS0120 variable to Nothing and then opening it up again like this:
Dim qry as AccpacComapi.AccpacView
DBLink.OpenView "CS0120", qry
qry.browse "UPDATE sometable ... blah"
set qry = nothing
DBLink.OpenView "CS0120", qry
qry.browse "UPDATE someothertable ... blah"
set qry = nothing
But I've learned that calling .RecordClear resets everything:
Dim qry as AccpacComapi.AccpacView
DBLink.OpenView "CS0120", qry
qry.browse "UPDATE sometable ... blah"
qry.RecordClear
qry.browse "UPDATE someothertable ... blah"
set qry = nothing