I use two common method to insert, update or delete records on database, they are
//rs is adodb.recordset
rs!Id = text1.text
rs!Name = .....
//db is adodb.connection
the Qustions are :
which one do you think the best to use???
why you choose it??
any other simple&powerful method to doing this??
: //rs is adodb.recordset
: rs!Id = text1.text
: rs!Name = .....
: //db is adodb.connection
: the Qustions are :
: which one do you think the best to use???
: why you choose it??
: any other simple&powerful method to doing this??
Execute require you to create a stored procedure in SQLserver and just call it anytime and much faster than new, update. but if you do not know how to create a stored procedure then use new, update.
when you do...
.fields(0) = "x"
It process the data through the client then request update from the server since you are using the ADO control. It uses your Physical memory.
And when you do...
It requests the SQL to be processed server side since you are passing the whole request into the server without having it processed through the control.
Correct me if I am wrong but this is how I understand this.