Displaying column names rather than title names in a Result Set?
a
anonymous
started a topic
almost 10 years ago
[This topic is migrated from our old forums. The original author name has been removed]
Hi -
Is there a setting in DBVisualizer that will show the actual column names in the results set as opposed to the TITLE name.
For example, my query returns 'Employee ID' and 'Customer ID' rather than EMPLY_ID and CSTMR_ID.
Here is how those 2 attributes are defined:
EMPLY_ID DECIMAL(18,0) TITLE 'Employee ID' NOT NULL,
CSTMR_ID DECIMAL(18,0) TITLE 'Customer ID' NOT NULL
Thank you in advance..
Re: Displaying column names rather than title names in a Result Set?
Hi,
Open Tools->Tool Properties and select the General / Grid category to the left. Now to the right scroll down a bit and you will find "Show Column Alias as Column Label". Uncheck it press OK and then try again.
Regards
Roger
a
anonymous
said
almost 10 years ago
[This reply is migrated from our old forums. The original author name has been removed]
Re: Displaying column names rather than title names in a Result Set?
Roger,
Thank you very much. That worked!
Best,
Conor
anonymous