-users-boun...@sqlite.org] On Behalf Of Jan Hudec
Sent: Monday, July 18, 2011 1:51 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Script-friendly execution of sqlite3.exe for
initializing a DB
On Thu, Jul 14, 2011 at 16:20:56 -0500, Marvin Bellamy wrote:
I want to run sqlite3 from
I want to run sqlite3 from a script (actually from a ToolTask in the MSBuild
environment) and get it to create a database without dropping into
interactive mode. It looks like ToolTasks don't like the redirection
operator (they're interpreted as string literals), so this won't work:
Sqlite3
Can anyone explain why these queries don't work? And, is there a
workaround?
create table t1 (id int);
create table t2 (id int, name varchar(32));
create view v1 as select a.id, b.name from t1 a, t2 b where a.id=b.id;
select * from v1 where a.id=1;
select * from v1 where t1.id=1;
select *
Thanks for the join tip. This must be a 3.2.1-specific bug, because
that last example doesn't work for me. Looks like its been reported
already.
--
Marvin Keith Bellamy
Software Engineer
Innovision Corporation
913.438.3200
Stephen Leaf wrote:
On Thursday 07 July 2005 02:19 pm, Marvin