Disconnected Recordset

[André]

Hello there:
I was wondering how do you work with disconnected recordsets when achieved using the command object and Stored procedures.

My situation:
I call from VB a stored procedure and retrieve a recordset.
Now I want to close the connection and do some changes to the recordset.

This far so good, I understand the technique.
The thing is, now when I reopen the connection, how do I update this Stored procedure?, is it necessary not to use a stored procedure when batchupdating?

I prefer to use the storedprocedure.

Please help

best regards
André

[Clunietp]

I don't think you'll be able to filter out the changed records (unless you use a timestamp and compare them in your sp), I would suggest using a batchupdate....