Subject | RE: [IBO] Error in calculations SQL |
---|---|
Author | Jason Wharton |
Post date | 2007-01-21T00:48:31Z |
> When I make the following one I calculate by means of a sentence SQL:I'm pretty sure this is also solved in Beta 15 along with the issue of
>
> SELECT sum(coalesce(Precio, 0) * coalesce(Cantidad, 1) *
> (100-coalesce(Descuento, 0))/100)*1.16 as TotalAlbaran
> FROM LinAlbaranes LIN
> WHERE AnoAlbaran=2007 and SerieAlbaran=0 and idAlbaran=36
>
> Leaves an error to Me 'Invalid KeyLinks entry: LIN.ANOALBARAN', I am
> using beta 14
Martijn's problem getting the DB_KEY column added in when a COUNT( * ) query
was performed. There was a defect in the method that determines if the
query is aggregating or not.
Please test Beta 15 and let me know.
Jason