I guess I forgot to mention the context. I'm interested in doing this from the cmd shell.
-----Original Message----- From: Igor Tandetnik [mailto:[EMAIL PROTECTED] Sent: Thursday, March 01, 2007 4:02 PM To: SQLite Subject: [sqlite] Re: Any way to know the numbers of rows affected by a cmd? Anderson, James H (IT) <Jim.Anderson-/PgpppG8B+R7qynMiXIxWgC/[EMAIL PROTECTED]> wrote: > For a select, the number of rows selected. Just count them as you step through them. > For an update, the number of rows updates. > > For a delete the number of rows deleted. sqlite3_changes, sqlite3_total_changes Igor Tandetnik ------------------------------------------------------------------------ ----- 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] -----------------------------------------------------------------------------