: [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
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
> 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.
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
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
5 matches
Mail list logo