Re: [sqlite] aliasing columns in views

Am Mittwoch, 17. März 2004 16:17 schrieb Puneet Kishor: [...someting about aliasing columns in views...] Send an email to [EMAIL PROTECTED] I think this will answer your question. > == > > Is there an archive of these mailing lists where I can view previous > posts? Send an email to [EMAIL P

Re: [sqlite] aliasing columns in views

Andre Vehreschild wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, you're sure this command resulted not in an error. As far as I understand the documentation the VIEW keyword is mandatory when creating a view. So this should be: CREATE VIEW qry_contacts AS My apologie

Re: [sqlite] aliasing columns in views

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, you're sure this command resulted not in an error. As far as I understand the documentation the VIEW keyword is mandatory when creating a view. So this should be: > CREATE VIEW qry_contacts AS > SELECT c.contact_id, c.firstname, c

[sqlite] aliasing columns in views

First time post, so the appropriate advance apologies apply -- The following situation has me mystified. I created a view, say, like so -- > CREATE qry_contacts AS > SELECT c.contact_id, c.firstname, c.lastname, > (CASE >WHEN >(c.firstname & c.lastname) ISNULL >THEN >