All Forums General
Thorkil 3 posts Joined 07/14
02 Dec 2014
Add title to view column

Hi
Try to find some info about how to add info into a Title attribute for a View Column... No luck...
I can stuff Comment into all objects, and Titles into table columns, but view columns... no  !
Is it against some nature of the TD database ?
Any hints ?
 
Regards
/T

Glass 225 posts Joined 04/10
02 Dec 2014

Thorkil,

 

You can list the columnnames you want first.

 

REPLACE VIEW dbname.viewname (Columnnameyouwant)

AS Lock Row for access SELECT columnnameyouhave FROM dbname.tbname

 

 

Rglass

dnoeth 4628 posts Joined 11/04
02 Dec 2014

You can add a title, but it's not shown in dbc.ColumnsV or HELP TABLE:

REPLACE VIEW testview AS
SELECT InfoKey (TITLE 'bla') FROM dbc.dbcInfoV WHERE InfoKey = 'VERSION';

 *** View has been replaced.
 *** Total elapsed time was 1 second.

 BTEQ -- Enter your SQL request or BTEQ command:
SELECT ColumnName, ColumnTitle FROM dbc.ColumnsV
WHERE TABLENAME = 'testview' AND DatabaseName = USER;

ColumnName         ColumnTitle
-----------------  -----------
InfoKey            ?

 BTEQ -- Enter your SQL request or BTEQ command:
SELECT * FROM testview;

 *** Query completed. One row found. One column returned.
 *** Total elapsed time was 1 second.

bla
------------------------------
VERSION

 
 

Dieter

You must sign in to leave a comment.