🚀 go-pugleaf

OK. I downloaded the freshly updated SP2-binaries now and tried it out and 
it seems like the alias-problem (at least on the Windows-server on which I 
tested) has been fixed. Can anyone from R&D (Sriram?) confirm this since I 
haven't been able to locate the list of changes for the updated SP2-package.

Regards,
Kjell Ljungqvist


"Brian Ellul" <brianellul@ecenglish.nospan.com> wrote in message 
news:46a9e5bb$1@newsgroups.borland.com...
> 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'
>>>
>>
>>
>
>