Re: Aliasing column names from a stored procedure - Possible?
George Cutrell wrote:
>
> Is it possible to alias a column name (or return variable) as it is
> returned from a stored procedure? For example with sql it is done as
> follows:
>
> select FIRST_NAME firstName, LAST_NAME lastName
> from ACCOUNT
>
> yields
>
> firstName lastName
> --------- --------
> Bob Allen
> Cathy Allen
>
In a word:
NO. >8-(
If you invoke a stored procedure from dbaccess, the results come back
with the heading (expression).
--
-- Jake
. .
_..-'( )`-.._
./'. '||\\\\. }\\_/{ .//||` .`\\.
./'.|'.'||||\\\\|.. )o o( ..|//||||`.`|.`\\.
./'..|'.|| |||||\\`````` \\'@'/ ''''''/||||| ||.`|..`\\.
./'.||'.|||| ||||||||||||. | .|||||||||||| ||||.`||.`\\.
/'|||'.|||||| ||||||||||||{ | }|||||||||||| ||||||.`|||`\\
'.|||'.||||||| ||||||||||||{ | }|||||||||||| |||||||.`|||.`
'.||| ||||||||| |/' ``\\||`` | ''||/'' `\\| ||||||||| |||.`
|/' \\./' `\\./ \\!|\\ /|!/ \\./' `\\./ `\\|
V V V }' `\\ /' `{ V V V
\\ \\ \\ V / / /
+-----------------------------------------------------------+
| Impeccable Logic: A thought process which successfully |
| resists chicken bites |
+-----------------------------------------------------------+