On 2013.07.29 6:08 PM, Roman Fleysher wrote:
Thank you, SQLiters, for confirmation. Yes, the set up is unusual. I have a
table which essentially maps existing column names to the names the users want
to see.
columnRenameTable(table, column, showAS)
The goal was to use this mapping for
SELECT table.column AS showAS FROM table;
when displaying the table.
What kind of users are these? Shouldn't you be doing that in the presentation
layer anyway? Besides the names you'd probably show fields formatted in
different ways too, depending on their type or meaning.
Also, SQLite does support views, you could define views having the names that
the users want. In fact, that's what views are for, letting different users
have different interfaces to the same database.
-- Darren Duncan
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
