Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 339
  • Last Modified:

How to update a record in a sql database using ADO?

Hi,

How can I update a record in a sql database using ADO?

I would prefer not to use the SQL Update statement.

Thanks,
Ward.
0
whorsfall
Asked:
whorsfall
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
in short: you open a recordset on the specific record, and do the update:
http://msdn.microsoft.com/en-us/library/windows/desktop/ms676529%28v=vs.85%29.aspx
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
I also see you posted another question for specifically powershell:
http://www.experts-exchange.com/Programming/Languages/Scripting/Powershell/Q_28485995.html
considering that question, I would suggest you delete this one here, as it's rather a duplicate
0

Featured Post

Who's Defending Your Organization from Threats?

Protecting against advanced threats requires an IT dream team – a well-oiled machine of people and solutions working together to defend your organization. Download our resource kit today to learn more about the tools you need to build you IT Dream Team!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now