Current recordset does not support updating 3251
Please share any comments or criticisms to this forum for others to benefit. VALUE_ID FROM tbl MSA);" ' Connect catalog container to current project cat T. Connection ' Create Temp Table structure With new TBL . -- AUTOINCREMENT OR PRIMARY KEY -- Error Duplication of Records . Append "VALUE_ID", ad Integer ' These commented lines are only shown for example - Do not use! Properties("Auto Increment") = True ' Add the primary key 'new Key. 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.I didn't read the code carefully though, so may have missed them. Firstly you might take a shot at changing some of your coding habits. When you are accessing recordset fields it is important to identify the field with something other than 0, 1 and 2. Or are they supposed to be in the code where you have the "UPDATING STUFF HERE" type comment? You will always have to check back to see what they mean. When you are accessing recordset fields it is important to identify the field with something other than 0, 1 and 2. This may be a limitation of the provider, or of the selected locktype(Although the record get updated when I update single record).
Then you need to do an Update on it when finished modifying the fields. Clearly the FAQs don't always contain the answers, but if they do then they are generally better than a reply to a thread - because those of us who write FAQ articles typically spend about 50 times as long writing them (including checking documentation, testing code, searching previous threads for alternate solutions/caveats, etc). take it easy on the people asking questions geek man. Those are the places you should be looking - especially the FAQs, as they are a fairly short and simple list of bullet points (with shortcuts to each section, so you can quickly drill-down to the part that is likely to answer your question). your 28,365 posts Jul 02 are probably mostly this kind of arguing due to you being the biggest know it all of this subject...Hello, I searched for the solution, but I couldn't find a clear answer. This may be a limitaion of the provider, or the selected locktype." I have researched the locktype enum and the provider information.