Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sqlmom
Starting Member
5 Posts |
 Posted - 2002-10-16 : 14:25:24
|
I want to update a recordset that a retrieve by executing a sp through a command object. I've read there are better ways to do this, but is this possible? How do you do it--I've been trying but keep getting quote:
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype. 0
which I understand because I have not set a cursortype or locktype anywhere. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-10-16 : 15:04:09
|
| Can you provide some table structures, the code you're using now, and what needs to be updated? It will help.Basically, you would not use the ADO Recordset object to do the updating (via the Update method) Instead, you'd either write a stored procedure that accepts parameters and perform the update, or write a SQL UPDATE statement that incorporates those values and EXECUTE it. It is much better to use stored procedures, they are more powerful, flexible, and efficient and easier to manage.If you can provide the details about the table structures we can probably write something that you can use. |
 |
|
|
|
|
|
Update recset retreived from cmdobj