ado update method or query?

[VBmim]

Hello

I am using ado for a connection with a sqlserver database.
My question is:
What goes faster?
- the ado update statement?
recordset.addnew
recordset!fields = "blabla"
recordset!fields2 = "blabla2"
recordset.update
- an sql query
command.execute "insert into table(fields, fields2)
value (blabla ,blabla2)"

greetz

Mim

 

[Donought]

The sql statement because it is a straight execute against database rather than an object.

 

[getimran]

hi,
surely update method without any doubt !!!

bye Make habit of marking posts as helpful or expert post, if they do solve your problems.