-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 bezpla...@jabse.com wrote: > Can you told me, how to find number of rows, of already > prepared SELECT query.
SQLite doesn't work that way. It calculates the next result row when you ask for it, rather than calculating all of them up front. To find out how many rows there are is as much work as calculating them all so it is bad form to write code that way. If you absolutely have to then use 'select count(*) from .... your original query ...' to get the count and then run the original query. This will do the work twice. Unless you wrap the whole thing in a transaction it is also possible for the number of rows between the two to differ. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkmjFZ0ACgkQmOOfHg372QRerACeIjrzgoKRpok5RWeMSW5t79bT FXIAn1SjdFjAM1AKmQjp7i2ZyoDZzIuO =rp2t -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users