[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 127
  • Last Modified:

ADO: Read And Write Recordset with Command.Execute

-I want to open a recordset with command.execute "stored procedure"
-I want that the recordset isn't just readonly
-I want that when I delete a record in the recordset the database isn't affected - just the recordset.
-I want to search, move etc. in the recordset

how can I do that?

(I tried I with recordset.open but as I had a look at the tracer I noticed that it's always doing cursor fetches (and not just one stored procedure)
0
gautschi
Asked:
gautschi
1 Solution
 
vbyuvalCommented:
You can use the transactions :

Transaction is set of commands on
database which you can "RollBack"
I mean you can execute
 commands and than change your
mine and take them back
without update the database .

Is that what you need ???
If that is I will send you the rest of
what you have to know about it .

                                      Enjoy
                                 Yuval Amir
0
 
Jon_RaymondCommented:
You could create an array and place all the values in it.  Then manipulate the data in the array.
0

Featured Post

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now