Re: Select As question
From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Sun, 21 Mar 2010 19:12:25 +0100
Message-ID: <80n5saF596U2_at_mid.individual.net>
On 03/21/2010 06:46 PM, Tony Sequeira wrote:
> GhostBuck wrote:
>
> Try with double quotes, so:
>
> Select bdate as "[Date of Birth]" from ....
>
> May help. Know nothing about ADO, pardon if this has been tried and
> discarded.
Date: Sun, 21 Mar 2010 19:12:25 +0100
Message-ID: <80n5saF596U2_at_mid.individual.net>
On 03/21/2010 06:46 PM, Tony Sequeira wrote:
> GhostBuck wrote:
>> In SQL I am able to select a field as something else. I will use this >> in generic function for naming grid columns readable to the user. >> >> e.g. Select bdate as [Date of Birth] from .... >> >> Oracle via ADO does not seem to like the [] around the "AS" name. How >> would I accomplish this in Oracle?
>
> Try with double quotes, so:
>
> Select bdate as "[Date of Birth]" from ....
>
> May help. Know nothing about ADO, pardon if this has been tried and
> discarded.
I believe double quotes are quite standard in SQL land. So my first choice would be
Select bdate as "Date of Birth" from ....
Kind regards
robert
-- remember.guy do |as, often| as.you_can - without end http://blog.rubybestpractices.com/Received on Sun Mar 21 2010 - 13:12:25 CDT