Re: [sqlite] except and select

On 10 Aug 2009, at 3:59am, Gene Allen wrote: > 1) do a select into a temp table and then run a bunch of queries to > remove > records based on another query (this might require substantial code > changes) > > Or 2) use the 'except' clause in query. Yeah: (1) do it in software. Sometimes

Re: [sqlite] except and select

The customer's requirements has gotten worse and these queries are getting very ugly, so I think I should either: 1) do a select into a temp table and then run a bunch of queries to remove records based on another query (this might require substantial code changes) Or 2) use the 'except' clause

Re: [sqlite] "Bad CPU type in executable"?

Anyway I can get gmail to post in the middle? :) (smiley face) -- Jim "Jed" Dodgen j...@dodgen.us ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Merging blobs on disk without taking up memory???

If you map each BLOB into virtual memory and create an anonymous mapped file to receive the concatentaed result toy can handle the blobs without using your stack and heap memory. Of course this assumes that you are using a POSIX OS (e.g. Windows or Unix/Linux). sorka wrote: > Hi. I have a

Re: [sqlite] "Bad CPU type in executable"?

John Elrick wrote: > As to the other...the economy is imploding, the ice caps are melting, > Moore's Law has finally been halted, and two sovereignties denoted with > the status of being terrorist supporting nations possess the bomb...and > we're worried about where a couple of sentences go in

Re: [sqlite] "Bad CPU type in executable"?

Hamish Allan wrote: > On Fri, Aug 7, 2009 at 1:01 PM, Jean-Denis Muys wrote: > > >> The point is made many times by many of those references found with >> Google. >> and the appeal to the web clearly invalidates the claim that I don't >> know the meaning of evil, at least in

Re: [sqlite] ANN: C#-SQLite 3.6.16

I hacked this port to run on Silverlight, as a proof of concept: http://www.itwriting.com/blog/1695-proof-of-concept-c-sqlite-running-in-silverlight.html Tim ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] "Bad CPU type in executable"?

Jim -- I agree with your sentiments. But as Dr. Kirkby is alleged to have once said ... Jim Showalter wrote: > I really really hate top-posting. > > - Original Message - > From: "Dr. David Kirkby" > To: "General Discussion of SQLite Database"

Re: [sqlite] "Bad CPU type in executable"?

I really really hate top-posting. - Original Message - From: "Dr. David Kirkby" To: "General Discussion of SQLite Database" Sent: Saturday, August 08, 2009 11:28 PM Subject: Re: [sqlite] "Bad CPU type in executable"? > J. King wrote:

Re: [sqlite] "Bad CPU type in executable"?

J. King wrote: > On Wed, 05 Aug 2009 12:50:15 -0400, Jean-Denis Muys > wrote: > >> You're top-posting, it's evil, the thread is becoming messy. That said... > > My impression has long been that top-posting is common and largely > unavoidable here, and no matter the