For overall performance and efficiency, I recommend you keep the "pretty" in the GUI where such things are traditionally implemented. Pick two of three: "COOL, Fast, Tight."
Fred -----Original Message----- From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]on Behalf Of Gilles Ganault Sent: Tuesday, July 14, 2009 11:02 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] [Columns] Keeping internal + beautified names? On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen <j...@dodgen.us> wrote: >I would just use: > >SELECT id AS Identification FROM foobar Thanks. This is what I already use for displaying the results, but then I'm stuck when I need to perform INSERT/UPDATES because I need to get the actual columns names :-/ It'd be cool if each column in a table could have an internal name and an external name. Is there a better way than either using the very first row in each table or keeping a table for this purpose? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
