Current recordset does not support updating vbscript

This may be a limitation of the provider, or of the selected locktype. Don Smith (remove the anitspams to email) Don, the error that I sometimes get is something like "Must use an Updateable Query" To fix this, I: 1. Recordset (0x800A0CB3) Current Recordset does not support updating. In ADO, this object is the most important and the one used most often to manipulate data from a database.When you first open a Recordset, the current record pointer will point to the first record and the BOF and EOF properties are False.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.The SQL server is running Windows 2000 Server and SQL 2000 The www ... Add New and then doing rs Users.fields("whateverfield") = something BUT, when retrieving information into a recordset and displaying that info in a form and then modifying that info by using the same command rs Users.fields("whatever") = newsomething it crashes with the following error: Error Type: ADODB.When I first started working with ADO in ASP I ad the same problem.

current recordset does not support updating vbscript-75current recordset does not support updating vbscript-23current recordset does not support updating vbscript-68current recordset does not support updating vbscript-17

I have a ASP page where a user will upload a excel file. This may be a limitation of the provider, or the selected locktype. If you need a Recordset object with more functionality, first create a Recordset object with the desired property settings, then use the Recordset object's Open method to execute the query and return the desired cursor type.(Got this from a help file) muskad202 The results are in for the 15th Annual Expert Awards! url=/library/en-us/dnima01/html/ima0501I think you'll probably want to use ad Open Keyset if you are connecting to a JET database (eg MS Access) hope this helps!This may be a limitation of the provider, or of the selected locktype(Although the record get updated when I update single record). Close Set rs Move Node Down = Nothing end if rs Move Node Down("Parent") = i Parent rs Move Node Down("Ordr") = i Node 1 rs Move Node Down. Move Next i Node = i Node-1 wend Pay attention to your Lock Type Try changing: s Move Node Down.

Leave a Reply