🚀 go-pugleaf

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'
>