Article View: borland.public.interbase.sql
Article #762Can Compile this statement
From: Brian Ellul
Date: Wed, 27 Jun 2007 07:33
Date: Wed, 27 Jun 2007 07:33
17 lines
1501 bytes
1501 bytes
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?
Regards
Brian
Technical Details
Message-ID:
<468211ea@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 114a0e,9dc1e417b6fe5383,start X-Google-Attributes: gid114a0e,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Brian Ellul" <brianellul@ecenglish.nospan.com> Newsgroups: borland.public.interbase.sql Subject: Can Compile this statement Date: Wed, 27 Jun 2007 09:33:36 +0200 Lines: 19 Organization: European |Centre 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; Original NNTP-Posting-Host: 213.165.165.162 Message-ID: <468211ea@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1182929386 213.165.165.162 (27 Jun 2007 00:29:46 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail