Re: Can Compile this statement

Article View: borland.public.interbase.sql

Article #769

Back to borland.public.interbase.sql Previous Next

#769

From: Wayne Niddery [TeamB]
Date: Wed, 27 Jun 2007 15:29

25 lines
2102 bytes

Brian Ellul wrote:
> I have a SP which used to compile under IB7.1 but doesn't with IB2007!
>
> Update InvDtl I
> Set    I.GrossAmount = I.GrossAmount + :AmountDifference_G,
>         I.NetAmount   = I.NetAmount   + :AmountDifference_N
> Where  I.CompanyID   = :iCompanyID
> And    I.InvID       = :iInvID
> And    I.LineType Not In ('A','C')
> And    I.RowCounter  = :MinRow
> And    I.ProductID   = :ProductID;
>
> error: alias I conflicts with an alias in the same statement
>
> If I remove the alias 'I', then it's fine. Was this changed in IB2007?

That's weird, I don't see anything in the statement that should cause this 
error, it all looks good to me. If you can spare the time, maybe you could 
narrow down more what "offends" IB2007 - is it one of the items in the set 
clause or the where clause, is it just one or any? Looks like a bug.

-- 
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"Nature abhors the vacuum tube." - J.R. Pierce, Bell Labs engineer who
coined the term 'transistor'

Technical Details

Message-ID: <4682823d$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!217.73.144.44.MISMATCH!ecngs!feeder.ecngs.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <468211ea@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: 114a0e,9dc1e417b6fe5383
X-Google-Attributes: gid114a0e,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
From: "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca>
Newsgroups: borland.public.interbase.sql
References: <468211ea@newsgroups.borland.com>
Subject: Re: Can Compile this statement
Date: Wed, 27 Jun 2007 11:29:02 -0400
Lines: 27
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 69.17.170.228
Message-ID: <4682823d$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1182958141 69.17.170.228 (27 Jun 2007 08:29:01 -0700)
X-Authenticated-User: wniddery
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder3.cambrium.nl!feed.tweaknews.nl!217.73.144.44.MISMATCH!ecngs!feeder.ecngs.de!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message