RE: [sqlite] coding style
Also, the data types (in 2.8.15) do not appear to copy over into the newly created table... I had to manually create the table with SQL, then insert into it from the query. -Original Message- From: Jakub Adámek [mailto:[EMAIL PROTECTED] Sent: Monday, December 13, 2004 3:08 PM To: [EMAIL PROTECTED] Subject: Re: [sqlite] coding style Yes but then I must repeat the column names in every query in which I use the view. It is a bug in SQLite, isn't it? Jakub Brass Tilde ([EMAIL PROTECTED]) wrote*: > > > create view myview as select t1.a a from t1 inner join t2 on > > t1.a=t2.a; create table problem as select * from myview; > > Change this last line to: > > create table problem as select a as a from myview; > > That creates the problem table with just "a" as the field name. >
Re: [sqlite] coding style
Yes but then I must repeat the column names in every query in which I use the view. It is a bug in SQLite, isn't it? Jakub Brass Tilde ([EMAIL PROTECTED]) wrote*: > > > create view myview as select t1.a a from t1 inner join t2 on t1.a=t2.a; > > create table problem as select * from myview; > > Change this last line to: > > create table problem as select a as a from myview; > > That creates the problem table with just "a" as the field name. >
Re: [sqlite] coding style
> create view myview as select t1.a a from t1 inner join t2 on t1.a=t2.a; > create table problem as select * from myview; Change this last line to: create table problem as select a as a from myview; That creates the problem table with just "a" as the field name.
Re: [sqlite] coding style
Hi all, I have a nasty problem with VIEWs and column names. I create a VIEW by joining two tables. If I use this view to create the table 'problem', the column name "t1.a" appears instead of the expected (and needed) "a". Is it a bug? Do you have an idea how to use the view so as it works? Thanks, Jakub create table t1 (a,b); create table t2 (a,c); insert into t1 values (1,2); insert into t2 values (1,3); create view myview as select t1.a a from t1 inner join t2 on t1.a=t2.a; create table problem as select * from myview;