RE: [sqlite] Can't order a view with joins

Our system is customisable, in that the users can add extra fields and tables, or create their own views, or customise the existing views to suit themselves. Hardcoding SELECT's within the software would seriously degrade the flexibility of the product. By having the product do a SELECT * on a

[sqlite] Version 2.8.7

Version 2.8.7 of SQLite is now available on the website. This release includes several new experimental APIs and some changes and improvements to the experimental date/time functions. If you have been keeping up with the changes in CVS, there is nothing new here. I just felt it was time to

Re: [sqlite] How do I get the last item in a list.

Liz Steel wrote: Also, how do I access the archive of messages sent to this list now that it's moved from Yahoo? Thanks to WWW::Yahoo::Groups, a magnificent Perl module, I archived the old messages: http://www-lnc.usc.edu/~brannon/sqlite-mail-archive/ungzipped/new/ You can get a tarfile

[sqlite] Random Row Selection

In access, I use the following statement to select a random row: "SELECT TOP 1 * FROM Questions WHERE Not QuestionID IN (0) ORDER BY RND(QuestionID)". How might I accomplish this same thing in SQLite? -- Eric Pankoke Programmer Christian Family Software http://www.christianfamilysoftware.com/