🚀 go-pugleaf

Appologies, found (dumb) mistake I was making.

Please ignore this post.

Thanks.


On Wed, 27 Jun 2007 09:35:52 +0100, Paul <nospam@sdiespammersdie.com>
wrote:

>I did a quick check online and it does not appear as a reseved word
>for IB6 abyway AFAIK. However, I often find problems when fields are
>just called "name".
>
>For example, the following procedure parses ok in IBConsole but
>generates an error when executed...
>//=======================================
>CREATE  PROCEDURE GET_CUSTOMER
>(
>  ....
>)
>RETURNS
>(
>  .....
>)
>AS
>BEGIN
>FOR SELECT NAME ,ADDRESS_1,ADDRESS_2,ADDRESS_3,ADDRESS_4,ADDRESS_5
>FROM CUSTOMERS WHERE UPPER(ACCOUNT_REF) =:CUSTREF INTO
>:CNAME,:CADDR1,:CADDR2,:CADDR3,CADDR4,CADDR5
>DO SUSPEND;
>END
>.. etc.
>
>//=======================================
>
>However, if I change it from ..
>
>...FOR SELECT NAME ..
> To
>...FOR SELECT NAME AS ANAME ..
>
>All is ok. No errors. 
>
>Strange ?
>
>Thanks.
>
>OS : Windows XP Service Pack 2
>Delphi : 2005 Service Pack 3 Installed
>CPU : AMD 3500+

OS : Windows XP Service Pack 2
Delphi : 2005 Service Pack 3 Installed
CPU : AMD 3500+