On 10/25/06, Da Martian <[EMAIL PROTECTED]> wrote: [...]
But to return all the rows just to count them requires N calls to step. If the data set is large you only want to return a subset to start with. So you wouldnt know the count. If you dont know the count, you cant update GUI type things etc..
There is another alternative if you don't mind to have the overhead of having an automatic row count (which sqlite avoids by design). It's by having a trigger that will update the table row count on each insert/delete. I'm not good with triggers, but this was already mentioned on the list and a quick google showed this sample SQL code here: http://www.northcode.com/forums/archive/index.php?t-6852.html <copy/paste from unknown origin and untested code> CREATE TABLE rowcount ( name TEXT, rows INTEGER); insert into rowcount VALUES ('myTable',0); UPDATE rowcount SET rows = (SELECT count(myNum) from myTable) WHERE name = 'myTable'; CREATE TRIGGER incrows AFTER INSERT ON myTable BEGIN UPDATE rowcount SET rows = rows+1 WHERE name = 'myTable'; END; CREATE TRIGGER decrows AFTER DELETE ON myTable BEGIN UPDATE rowcount SET rows = rows-1 WHERE name = 'myTable'; END; </copy/paste from unknown origin and untested code> After this you can easily access your row count with a SELECT rows FROM rowcount WHERE name = 'myTable'; Hope this helps, ~Nuno Lucas ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
