Hello, I need help using Case stmts in DBSIAM 4.22 build 3.  I am =
getting "Invalid use of non-aggregated column expression in Select SQL"

This is my sql statement and it gives me the above error.
SELECT dt."Transaction Code",
      dt."Initials",
      case
         when (dt."Transaction Code" in (13,14) then SUM(dt."Quantity")
         when dt."Transaction Code" in (22,26,9) then Count(*)
      end AS sumItems,
      case
        when (dt."Transaction Code" in (13,14)) then SUM(dt."Int Data =
1")
       when dt."Transaction Code" in (22,26) then Sum(dt."Quantity")
      end as SumTckts
FROM "Daily Transactions" DT
GROUP BY dt."Transaction Code", dt."Initials"
ORDER BY dt."Transaction Code"

Does not like me to use the IN  operator in the case statement.

Can you help me?

Semone

Simone,

<< Hello, I need help using Case stmts in DBSIAM 4.22 build 3.  I am getting
"Invalid use of non-aggregated column expression in Select SQL" >>

It's a bug - DBISAM should be making an exception for CASE WHEN expressions
(in this case, the IN clause) as well as IF expressions that determine the
branching, but it isn't.

A fix will be available in about a week in a new build.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


I think I'm correct in saying the fix for this will be in V4.22b5, but I've lost track somewhere.  Am I right?


Roy Lambert

Roy,

<< I think I'm correct in saying the fix for this will be in V4.22b5, but
I've lost track somewhere. Am I right? >>

Correct.

--
Tim Young
Elevate Software
www.elevatesoft.com

> I think I'm correct in saying the fix for this will be in V4.22b5,
> but I've lost track somewhere.  Am I right?

...wouldn't it be nice if the bug fix would be in 5.0.0.1 next week..

<bg>

ralf

Ralf,

<< ..wouldn't it be nice if the bug fix would be in 5.0.0.1 next week..
>>

Yes, it would be.  But alas, it will not.  I will have some screen shots
available within the next week of the ElevateDB Manager utility, however.


--
Tim Young
Elevate Software
www.elevatesoft.com

Tim Young [Elevate Software] wrote:

> Yes, it would be.  But alas, it will not.  I will have some
> screen shots available within the next week of the ElevateDB Manager
> utility, however.

will the screen shots be "production stable" or just "beta"..?



ralf

Ralf,

<< will the screen shots be "production stable" or just "beta"..? >>

Neither, they're simply screen shots.

--
Tim Young
Elevate Software
www.elevatesoft.com