[ADO] Can't update recordset

Question

I don't want to update data in DB. I just want to update data in the recordset to prepare the data to use.

With RS
    .CursorLocation = adUseClient
    .Open "execute StoredProcedure", DBCon, adOpenStatic, adLockOptimistic
    Set .ActiveConnection = Nothing
End With

I was once able to call update method successfully with the code above, when I passed a much simpler SQL statement to the open method of Recordset object instead.

This time I need to execute a complex stored procedure. I know it's impossible to update the basic datatables. Is there a way to just update the recordset and leave the DB untouched?