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: [email protected] [mailto:[email protected]]on Behalf Of Gilles Ganault Sent: Tuesday, July 14, 2009 11:02 AM To: [email protected] Subject: Re: [sqlite] [Columns] Keeping internal + beautified names? On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen <[email protected]> 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
