--- Ted Roche <[EMAIL PROTECTED]> wrote:
> On 7/10/06, Michael Hawksworth
> <[EMAIL PROTECTED]> wrote:
> > I have a select statement with a sum on a field
> that contains an iif
> > statement and it looks as though the iif is
> truncating the value...
> >
> > && Example
> >
> > select
> > sum(iif(SomeCondition,ValueX,0)) as
> TotalValueX
> > from
> > curATable
> >
>
> Sure. That's the SQL preprocessor running the query
> once and trying to
> figure out what size the resultant table columns
> should have - it's
> why you get single character fields from functions,
> too. Try it with
> something like:
>
> select
> sum(iif(SomeCondition,ValueX,00000.000)) as
> TotalValueX
> from
> curATable
>
or generally:
sum(iif(SomeCondition,ValueX,0^2))
Tibor
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
