Thanks - While looking through the sqlite.ijs script I see strtbl returns all rows. It grabs all 100,000 rows.
Moral - read the code when in doubt. On Fri, Nov 26, 2010 at 6:50 PM, bill lam <[email protected]> wrote: > I am not a user of sqlite. A quick glance at its script to find a line > MAXROWS=: 1000 > I think you can change that value. > > Птн, 26 Ноя 2010, John Baker писал(а): > > I have a quick question for users of SQLite. > > > > I cannot seem to get a query to return more than 1000 rows in either > J6.02 > > or J7.01. > > > > Consider the following - I have created a simple sqlite database that > > contains one table with 100,000 rows. > > > > load 'data/sqlite' > > > > NB. database file > > file=. 'C:\mp\cs\SqliteTest00\SqliteTest00\bin\Debug\test.db' > > > > NB. create sqlite object > > ]db=. file conew 'psqlite' > > +--+ > > |10| > > +--+ > > > > NB. count rows - confirms 100,000 rows > > strquery__db 'select count(*) from test' > > +--------+ > > |count(*)| > > +--------+ > > |100000 | > > +--------+ > > > > NB. fetch entire table - should return all rows. > > dat=. colquery__db 'select * from test' > > > > NB. returned row count is 1000 > > #&> dat > > 2 4 > > 1000 1000 > > > > This looks like a row limit is set somewhere in the sqlite interface. I > > cannot > > find it and I cannot get the remaining rows. Clearly I am doing > something > > wrong > > as a database that returns 1000 rows will not be very useful > > > > -- > > John D. Baker > > [email protected] > > ---------------------------------------------------------------------- > > For information about J forums see http://www.jsoftware.com/forums.htm > > -- > regards, > ==================================================== > GPG key 1024D/4434BAB3 2008-08-24 > gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm -- John D. Baker [email protected] ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
