Indeed, try: select count() ...
update count() ...
delete count() ...

Dr. Tom
----- Original Message ----- From: "Anderson, James H (IT)" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, March 01, 2007 3:40 PM
Subject: [sqlite] Any way to know the numbers of rows affected by a cmd?


For a select, the number of rows selected.

For an update, the number of rows updates.

For a delete the number of rows deleted.

jim
--------------------------------------------------------

NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error.


-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------

Reply via email to