Re: [sqlite] [Columns] Keeping internal + beautified names?

Hi Gilles, >> 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

Re: [sqlite] [Columns] Keeping internal + beautified names?

"Gilles Ganault" schrieb im Newsbeitrag news:0sap559atknanmiv8g83pdj6f83e8ve...@4ax.com... > On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen > wrote: > >I would just use: > > > >SELECT id AS Identification FROM foobar > > Thanks. This is what I already use

Re: [sqlite] [Columns] Keeping internal + beautified names?

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

Re: [sqlite] [Columns] Keeping internal + beautified names?

On Sat, 11 Jul 2009 09:38:27 -0700, Jim Dodgen 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

Re: [sqlite] [Columns] Keeping internal + beautified names?

I would just use: SELECT id AS Identification FROM foobar On Sat, Jul 11, 2009 at 8:33 AM, Gilles Ganault wrote: > Hello > > Apart from using a table for this very purpose, is there a way to keep > internal names and beautified names for a table's column names? > >

[sqlite] [Columns] Keeping internal + beautified names?

Hello Apart from using a table for this very purpose, is there a way to keep internal names and beautified names for a table's column names? Internal name = for the SQL queries, eg. "id" Beautified name = as column name in a grid object, eg. "Identification" Thank you.