jokah.com

13Aug/140

Cannot determine the result data type of the CASE or COALESCE function

Encountered the following error in PI OLEDB Tester while running a query using CASE:

"Cannot determine the result data type of the CASE or COALESCE function"

SELECT tag, time, CASE WHEN value < 0 THEN 0 ELSE value END FROM PIavg WHERE ...

Casting the 0 expression fixes this:

THEN CAST(0 AS float64)

Comments (0) Trackbacks (0)

No comments yet.


Leave a comment

No trackbacks yet.