recordset edit method in ADO?

[VBUser77]

Do you know what's the edit method to edit a recordset in ADO. I know in DAO we can use rst.Edit but it doesn't work for an ADO recordset.

Thanks in advance.

Jay

 

[PHV]

No need in DAO. You populate the Fields and commit the change by rst.Update

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[VBUser77]

you mean no need to use .Edit method in ADO?

 

[VBslammer]

No need in [red]DAO[/red] [blue]ADO[/blue]...

VBSlammer

"You just have to know which screws to turn." - Professor Bob

 

[PHV]

Sorry for the typo:
No need in ADO. You populate the Fields and commit the change by rst.Update

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[VBUser77]

Thanks a bunch!

 

[jjlogan]

If you are just editing a record in an ADO recordset, use Update method:
rst.Update "name of field", "value for field"
If you are going to make the same change to more than one record, consider opening a recordset using a select query sql with only records you need to change. Then add code to make the changes:
Do Until (rst.EOF)
rst.Update "field name", "value"
rst.MoveNext
Loop
Hope this helps.
Jeff