Re: Select As question
From: Tony Sequeira <nobody_at_127.0.0.1>
Date: Sun, 21 Mar 2010 17:46:31 +0000
Message-ID: <4ba65b75$0$2474$db0fefd9_at_news.zen.co.uk>
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?
Date: Sun, 21 Mar 2010 17:46:31 +0000
Message-ID: <4ba65b75$0$2474$db0fefd9_at_news.zen.co.uk>
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.
-- S. Anthony Sequeira ++ As usual, this being a 1.3.x release, I haven't even compiled this kernel yet. So if it works, you should be doubly impressed. (Linus Torvalds, announcing kernel 1.3.3 on the linux-kernel mailing list.) ++Received on Sun Mar 21 2010 - 12:46:31 CDT