-
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é
-
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....