Current recordset does not support updating

I've seen ASP code, C code & VB code with ADO classic and ADO. Don't know which way to turn - just trying to get this task finished (along with being guided down the correct path of learning about this). I thought my approach in the code below was a good solution, but apparently not. Command Type Cmd Text 'create and open record set POrst Data = New ADODB. I've seen ASP code, C code & VB code with ADO classic and ADO. Don't know which way to turn - just trying to get this task finished (along with being guided down the correct path of learning about this). I thought my approach in the code below was a good solution, but apparently not. I wish there was an example of someone reading a transaction file and updating a table (add, update & delete based on the transaction type). I have a website with some asp pages running off of a MS Sql db.For reasons that I can't explain, whenever querying the database with a SELECT query containing an order by clause, the returned recordset is read-only, regardless of cursor or lock type.I tried to modify the field in my ASP page, and it yields the following error: I tried to use ad Lock Optimistic as follows, but still not working obj RS.Open "pressrelease", obj Conn, ad Open Dynamic, ad Lock Optimistic ADODB.

Record Set And Check "str Archive Path" Should have last Char ="\" some thing like : C:\My Folder\Data\ Regards Veena I still get the same error...

This seems to be specific to the hosting provider I am using, as it works fine on development boxes.

My provider's support people don't know anything about this problem, and I have been unable to find useful information in the knowledge base.

When the query is first opened all settings indicate that the recordset is editable.

As soon as I try to add/Modify a record I get the following error: Current Recordset does not support updating.

Search for current recordset does not support updating:

current recordset does not support updating-40current recordset does not support updating-32

Would it be common, in your opinion or knowledge, that updateable recordsets are not supported?

Leave a Reply

Your email address will not be published. Required fields are marked *

One thought on “current recordset does not support updating”