RE: [sqlite] Is this possible in SQLite?

I guess this question is can I combine an UPDATE...SET with an INSERT...SELECT command? Thanks, John -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Thursday, March 17, 2005 4:32 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Is this possible in SQLite? John O'

[sqlite] Is this possible in SQLite?

Hello all, I have a fairly simple DB with two tables. I'm trying to combine a SELECT and UPDATE command, if it is possible: CREATE TABLE a (id PRIMARY KEY, data INT); CREATE TABLE b (id INT, data INT); INSERT INTO a VALUES( 1, 100 ); INSERT INTO b VALUES( 1, 101 ); INSERT INTO b VALUES( 1,

Re: [sqlite] BLOB versus table storage

Thanks for all the responses -- I will continue storing it in a BLOB (writing sequential list of doubles for x,y coordinates.) The points themselves will never be processed in a database query, only returned to a calling application. I appreciate everyone's comments! > > From: Noel Frankinet

Re: Re: [sqlite] BLOB versus table storage

Thanks for all the responses -- I will continue storing it in a BLOB (writing sequential list of doubles for x,y coordinates.) The points themselves will never be processed in a database query, only returned to a calling application. I appreciate everyone's comments! > > From: Noel Frankinet