🚀 go-pugleaf

Not really! I just removed the alias (seemed irrelevant in this case) and it 
compiled fine. Unfortunately, I didn't have time to continue experimenting 
this issue.

"Kjell Ljungqvist" <kjell@REMOVETHIS.iki.fi> wrote in message 
news:46a9ce64$1@newsgroups.borland.com...
> Hi!
>
> Did you find any solution or reason for this? We are too experiencing the 
> same kind of problem with IB2007. First it seemed like it only happened on 
> IB2007 on Linux but after updating a Windows-server to IB 2007 SP2 these 
> kind of problems started to appear there too. It caused so much trouble in 
> our application so we had to downgrade to IB 2007 SP1.
> The first (seemingly Linux-related) problem still exist though.
>
> I will try to get some appropriate test material gathered during the next 
> few days but would also like to know if anything followed from this 
> NG-question.
>
> Regards,
> Kjell Ljungqvist
>
>
> "Wayne Niddery [TeamB]" <wniddery@chaffaci.on.ca> wrote in message 
> news:4682823d$1@newsgroups.borland.com...
>> 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'
>>
>
>