Yeah,
that's what I've discovered so far is that you can't put spaces in it. I
think I've been round this loop before, but my memory is going with age :-)
-----Original Message-----
From: Nic Wise [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 3 May 2000 15:42
To: Multiple recipients of list delphi
Subject: RE: [DUG]: Interbase Queries
Yup, I think:
select myfield as MyNewFieldName
I'm just not sure you can quote it - or put spaces in it.
N
--
Nic Wise - 021.676.418 / [EMAIL PROTECTED] / Inprise/Borland New Zealand
Is it not a foolish man, said little Woo, who keeps all his chickens in his
trousers?
For at best, will he not suffocate his chickens, and, and worst, will he not
disappoint the ladies in the village? --Alexi Sayle
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Tony Sinclair
> Sent: Wednesday, 3 May 2000 15:47
> To: Multiple recipients of list delphi
> Subject: [DUG]: Interbase Queries
>
>
> Hi all,
>
> In various other databases, you can do a SELECT MyFieldName AS "New
> MyFieldName". Is there as equvalent for Interbase?
>
> many thanks
>
> Tony Sinclair
> Holliday Group Limited
> Christchurch
> New Zealand
> ------------------------------------------------------------------
> ---------
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
