Re: [sqlite] tables in in-memory database

Thanks Richard. It works now. Originally I tried using SQLITE_MASTER and it did not work so after searching this forum I found some info on SQLITE_TEMP_MASTER and tried that. I figured the reason why SQLITE_MASTER did not work originally is because I opened a new handle to the in-memory

Re: [sqlite] ORDER BY failure (?)

What behavior were you trying to achieve? Putting a conditional statement (test1 > 100) in a GROUP BY clause isn't valid SQL. Simon B. On Tue, 2004-02-10 at 17:54, Andox wrote: > Hello everybody. > > I have a question about the SELECT command with UNION ALL. > > When executing the

RE: [sqlite] How do I cross compile for FreeBSD

Hi Cory, sorry, I don't remember your previous post. What version of FreeBSD and SQLite are you interested in ? I have FreeBSD 5.2 and I compile SQLite (up to 2.8.11 so far) without problems. I'll try 2.8.12 tonight. I can publish a binary in 1 or 2 days. Is it OK ? Regards, Jarek Jaroslaw