Yes, thanks, I can do that but if the table is large it's quite slow. I was hoping there was a quicker way, as there is in sybase.
-----Original Message----- From: Tom VP [mailto:[EMAIL PROTECTED] Sent: Thursday, March 01, 2007 4:58 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Any way to know the numbers of rows affected by a cmd? Indeed, try: select count() ... update count() ... delete count() ... Dr. Tom ----- Original Message ----- From: "Anderson, James H (IT)" <[EMAIL PROTECTED]> To: <sqlite-users@sqlite.org> 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] ------------------------------------------------------------------------ ----- -------------------------------------------------------- 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] -----------------------------------------------------------------------------
