Depending on your cursor type, you may need to call the Requery method to make the new record accessible.
If you call Add New while editing the current record or while adding a new record, ADO calls the Update method to save any changes and then creates the new record.
and you did not define the record in the open recordset syntax. Do it as below- rs.open"select * from table1",conn,adopenstatic,adlockoptimistic I think this is work for your problem.
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.
Property Type = DLookup("[Property Type]", "[TBL_Property Type]", "IDProperty Type = " & rst!
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site.
Read Val Find settings that give you the supported operations you need with Also see for some info about supported operations of recordsets.
If the Recordset object does not support bookmarks, you may not be able to access the new record once you move to another record.
Text If op_Sex M = True Then sex = "Male" Else sex = "Famale" End If obj RS("Sex") = sex obj RS("Address") = txtb_Address. The preferred method, from an effeciency viewpoint is to: The reason for this is that, when declaring an ado object as new (Dim obj as New Connection), EVERY TIME the object is referenced, a block of code is run that checks to see if the object is empty, and if so, instanciates a new object, before the actual desired operation takes place. It also means that you can NEVER explicitly check to see if an object Is Empty if you declare it as new, because, if it is empty, it gets instanciated automatically. " - Bette Middler "It's a book about a Spanish guy named Manual.
The only time you explicitly release an object is if you explicitly instanciate it.
This may be a limitation of the provider , or of the selected locktype ." Set rs = New ADODB.
I think you sould use some sort of UPDATE SQL statement to do that Val Hi, First of all I think your recordset was opened as a read- only on server side.