<div>
You could create an array and place all the values in it. &nbsp;Then manipulate the data in the array.
</div>


You could create an array and place all the values in it.  Then manipulate the data in the array.

<div>
<div class="content wysiwyg-content">
-I want to open a recordset with command.execute &quot;stored procedure&quot;<br />
-I want that the recordset isn't just readonly<br />
-I want that when I delete a record in the recordset the database isn't affected - just the recordset.<br />
-I want to search, move etc. in the recordset<br />
<br />
how can I do that?<br />
<br />
(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)<br />

</div>
</div>


-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)


ADO: Read And Write Recordset with Command.Execute

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.