RE: [sqlite] How to get number of records in record set

2007-12-13 Thread Tom Parke
Thanks, that makes sense. Tom -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, December 13, 2007 7:50 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How to get number of records in record set "Tom Parke" <[EMAIL PROTECTED]> wrote: > If I

Re: [sqlite] How to get number of records in record set

2007-12-13 Thread drh
"Tom Parke" <[EMAIL PROTECTED]> wrote: > If I prepare() a sql stmt SELECT * FROM tbl WHERE col = n: > > How do I find out how many records were selected before calling step()? > The technically correct response to your question is that the answer is always zero. Nothing gets selected - the