Current recordset does not support updating locktype

I have one field in the table set to uniqueidentifier and I have newid() in the Default value field in Enterprise manager.

I added the above Cursor Location to see if problem went away, but it didn't. Michael Lee I have changed the above slightly but I'm getting the same results. Bob Just remove the space between faq and 222 - like this FAQ222-3670 ________________________________________________________________If you want to get the best response to a question, please check out FAQ222-2244 first'If we're supposed to work in Hex, why have we only got A fingers?

current recordset does not support updating locktype-75current recordset does not support updating locktype-66

The following is a chopped down version of my code... Open "Driver=; Dbq=c:\Website Projects\Exit Cash Flow\log M.mdb;" str SQL = "Select * From Main Where Username = '" & str Query & "' and Domain = '" & str Domain & "'" Set rs Main = cn. Close Set rs Main = Nothing ======= End of Code ========= .mdb;" str SQL = "Select * From Main Where Username = '" & str Query & "' and Domain = '" & str Domain & "'" rs Main. Execute (str SQL) method returns a read-only recordset. Open str SQL, cn) and that took me a few minutes to figure out why I was getting a '3001' error...

I have removed everything except the code dealing with the recordset...

You are currently viewing the Classic ASP Professional section of the Wrox Programmer to Programmer discussions. Open s SQL, obj Conn,2,2 ' ad Open Keyset Cursor Type While not rs Move Node Down. Open s SQL, obj Conn,2,2 ' ad Open Keyset Cursor Type To: s Move Node Down.

This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. I am getting the following error message when trying to update recordset in "While" looping: Current Recordset does not support updating. Recordset") s SQL = "SELECT * from Contents WHERE Parent = " & i Parent & " AND Ordr in(" & i Node & "," & i Node After & ") ORDER BY Ordr " 'Response. Open s SQL, obj Conn, ad Open Keyset, ad Lock Pessimistic ' ad Open Keyset Cursor Type - A.

This may be a limitation of the provider, or of the selected locktype.

If I check the Lock Type right after executing a addnew to the recordset the property changes to ad Lock Read Only. There is one other thing that I thought it could be. Here is an example of the code thats loading the recordset: If rs Insurance. Current provider does not support returning multiple recordsets. Current provider does not support returning multiple recordsets 10. I'm using SQL Server 2000, and I'm having a slight problem with a recordset from a stored procedure. Commit Trans Does somebody know what to do about this ? Error: current recordset does not support updating 5. Current provider does not support returning multiple recordsets from a single execution 7. Please let me know what I need to add to open this up in read/write. Addnew and displays the error Runtime error '3251' Current Recordset does not support updating.

Tags: , ,