Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Rows affected

Status
Not open for further replies.
keenanbr

keenanbr

Programmer
Oct 3, 2001
469
IE
I'm converting a vb prog whicj uses RDO to ADO. How do i get the rows affectedby an update command.

Public g_dbConn As ADODB.Connection
...
...
...
...
g_dbConn.Execute("UPDATE xxx SET .....")

Thanks in advance,
 
Sort by date Sort by votes
There is an example in the MS Access VBA help file headed "RecordsAffected Property Example"

________________________________________________________
Zameer Abdulla
Help to find Missing people
Sharp acids corrode their own containers.
 
Upvote 0 Downvote
in case anyone's interested what I did was

Dim recsaffected as int

g_dbConn.Execute("UPDATE xxx SET .....", recsaffected)

msgbox(recsaffected & " Records updated")

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

drgt
  • Locked
  • Question
xlsx splitter by rows
Replies
1
Views
240
Andrzejek
Andrzejek
djieon
  • Locked
  • Question
Insert Number of Excel rows based on a column 1
Replies
4
Views
231
SkipVought
S
PercyNK
  • Locked
  • Question
Data Adapter does not update all rows Edited
Replies
2
Views
137
PercyNK
PercyNK
Yorkshireman2
  • Locked
  • Helpful tip
Datagridview - prevent columns scrolling to right when changing rows
Replies
0
Views
168
Yorkshireman2
Yorkshireman2
Nctukek
  • Locked
  • Question
VBA Code: Copying rows from multiple sheets
Replies
1
Views
74
SkipVought
S

Part and Inventory Search

Sponsor

Back
Top