ADO Update/Insert

[hocheeming]

Hi everyone,

Just a simple question.

What is the best way to program ADO to insert and update record? We can use the "INSERT" SQL statement to insert into the database or use the "AddNew" command. So which is a better?

The same goes to Update. Specifically use the Update SQL statement or use the ADO equivalent method?

Thanks.

Regards,
Chee Ming

 

[tlbroadbent]

It depends... but executing SQL commands INSERT/DELETE/UPDATE will almost always be faster than using the equivalent ADO record set methods. If you want to get the best answer for your question read faq183-874 and thread183-468158.
Terry L. Broadbent - DBA
SQL Server Page:

http://tlbroadbent.home.attbi.com/sql/sql_articles.htm