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
