Exactly what I was hoping for! Thanks very much.
-Original Message-
From: Griggs, Donald [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 01, 2007 6:39 PM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Re: Any way to know the numbers of rows affected
by a cmd?
Regarding:
Anderson,
Regarding:
Anderson, James H (IT) wrote:
> I guess I forgot to mention the context. I'm interested in doing this
> from the cmd shell.
>
>
James,
You can use the command
pragma count_changes=1
in the shell to have it report the number of rows affected by insert,
update, or delete
Anderson, James H (IT) wrote:
I guess I forgot to mention the context. I'm interested in doing this
from the cmd shell.
James,
You can use the command
pragma count_changes=1
in the shell to have it report the number of rows affected by insert,
update, or delete statements (see
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?
4 matches
Mail list logo