On Thu, 18 Oct 2001, [iso-8859-1] F�bio Sato wrote:
> > > is very disappointing... I have a procedure that update 868 rows and it is
> > > taking more than 5 minutes to complete.
>
> I think that the source code may be a better answer to your questions,
> so this is basically what I'm doing:
>
> conn.Open "DSN=mydb;uid=username;pwd=mypassword"
conn.Execute("begin")
> For I = 0 To size - 1
> sql = "update mytable set value1 = " & array1(I) & ", value2 = " &
> array2(I) & _
> ", value3 = " & array3(I) & ... & ", value20 = " & array20(I) &
> -
> " where code = " & codes(I)
> conn.Execute(sql)
> Next I
conn.Execute("commit")
Does this help?
--
Joel BURTON | joel@joelburton.com | joelburton.com | aim: wjoelburton
Independent Knowledge Management Consultant