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
http://www.sqlite.org/pragma.html#modify for details).
A count(*) is the best way to get the number of rows a select will
return. There is really no shortcut way to do this in general, so it
does have to execute the select to find the rows to count.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
