Subject | Re: [firebird-support] "HAVING" Bug |
---|---|
Author | Alexandre Benson Smith |
Post date | 2008-10-28T17:01:28Z |
Leyne, Sean wrote:
Of course !
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br
> Alexandre,LOL
>
>
>> Shoudn't it be:
>>
>> Replace the HAVING clause with "having ABS(sum(glt_total)) < 0.0001"
>>
>> or something like this ?
>>
>
> You're right and wrong ;-}
>
> You're right, my SQL was wrong.
>
> You're wrong, the correct SQL should have been:
>
> having ABS(sum(glt_total)) > 0.0001
>
> Sean
>
Of course !
see you !
--
Alexandre Benson Smith
Development
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil
www.thorsoftware.com.br