Getting the number of rows affected by com.execute?

[joebickley]

Hi

I am passing an update statement into command. How can i get back the number of rows that were affected by the update statement?

Thanks

Joe

PS code....
dim com as command
com.CommandText = "UPDATE tblDANs SET DANStatus = xx WHERE DANnumber=yy"
com.Execute

 

[Rolliee]

msgbox dsum("DANumber","tblDANS", "DANumber = yy&quot

this will not give the number in yy but 'yy'. To get the number in "yy" you must to an & yy & &quot"

rollie@bwsys.net

 

[cmmrfrds]

The execute will pass back the records affected. I believe it is the second parm on the execute.

Dim numUpdated as Long

com.Execute , numUpdated

I know this works assuming the sql string is okay.
Dim sql1 as string

sql1 = "UPDATE tblDANs SET DANStatus = xx WHERE DANnumber =yy"
com.execute sql1, numUpdated