RE: [sqlite] coding style

2004-12-14 Thread Drew, Stephen
: [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

Re: [sqlite] coding style

2004-12-13 Thread Jakub Adámek
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; > > Ch

Re: [sqlite] coding style

2004-12-13 Thread Brass Tilde
> 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

2004-12-13 Thread Jakub Adamek
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? Than

[sqlite] coding style

2004-12-04 Thread Mateusz Łoskot
Hello, May be it's a kind of trivial question but I would like to know if it is possible to get some details about sqlite (source) coding style, some guidelines (tabs, spaces, indentation, etc.). I would like to follow it in my customization in some files. Could you give me some info? Best regards