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 John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Return number of rows affected

Status
Not open for further replies.
mike777

mike777

Programmer
Jun 3, 2000
387
US
Hello all.
When you run a delete statement, update statement, etc., is there a way to return information on the number of rows affected by your statement?
Thank you.
-Mike
 
Sort by date Sort by votes
Depending on what you use: yes.

In Delphi, try the "RowsAffected" property.


Martijn Tonies
Database Workbench - the developer tool for InterBase, Firebird, MySQL & MS SQL Server
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

tonytoney
  • Locked
  • Question
Removing Duplicate Rows
Replies
1
Views
188
bmarks
bmarks
bob1660
  • Locked
  • Question
Display the content of a BLOB field
Replies
1
Views
241
unclejimbob
unclejimbob
bmarks
  • Locked
  • Question
Is there a test to see if a character field contains a number?
Replies
4
Views
273
unclejimbob
unclejimbob
bmarks
  • Locked
  • Question
Blob field - new line / carriage return 1
Replies
10
Views
616
bmarks
bmarks
pranavjosh
  • Locked
  • Question
How can i change the owner of database
Replies
1
Views
166
MartijnTonies
MartijnTonies

Part and Inventory Search

Sponsor

Back
Top