RE: [sqlite] Re: Any way to know the numbers of rows affected by a cmd?

2007-03-02 Thread Anderson, James H \(IT\)
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,

RE: [sqlite] Re: Any way to know the numbers of rows affected by a cmd?

2007-03-01 Thread Griggs, Donald
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

Re: [sqlite] Re: Any way to know the numbers of rows affected by a cmd?

2007-03-01 Thread Dennis Cote
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

RE: [sqlite] Re: Any way to know the numbers of rows affected by a cmd?

2007-03-01 Thread Anderson, James H \(IT\)
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?