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:
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]
-