Which is better Add New or Insert ?

[Cap2010]

hi,

Below are two different code. Doing same task.
Which is better to use and effective ?

Code 1
rs.Open sql, Adoconn, adOpenDynamic, adLockOptimistic
rs.AddNew
rs.Fields("ItemCode").Value = "AWI01"
rs.Fields("Name").Value = "ABDEOD"
rs.Fields("DDATE").Value = Date
rs.Update

Code 2
execute.sql(insert.....)

Cap2010

 

[VBrit]

The best is to use stored procedures for your data access!

However to answer your question, executesql is faster.

Hope thisis helpful,

VBrit

 

[Dimandja]

AddNew is an ADO coding style. There is a negligible difference in performance.

However AddNew is at its best when used with this syntax from

http://msdn.microsoft.com/library/d...ry/en-us/his/htm/_sna_addnew_method_oledb.asp

:

[b]recordset.AddNew Fields, Values[/b]

[b]Fields[/b] 
This optional parameter specifies a single name or an array of names or ordinal positions of the fields in the new record.
 
[b]Values[/b] 
This optional parameter specifies a single value or an array of values for the fields in the new record. If Fields is an array, Values must also be an array with the same number of members; otherwise, an error occurs. The order of field names must match the order of field values in each array.