Can you use immediate iif in crystal report command object?

Can you use immediate iif in crystal report command object?
Select total
iif(a>0,a/100,b) as Total
from tableA
kktd58Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
mlmccConnect With a Mentor Commented:
I suspect the ODBC driver doesn;t support it.

mlmcc
0
 
mlmccCommented:
I don't know.  Does your database support it in the SQL?

Have you tried it?

mlmcc
0
 
peter57rCommented:
if your database's brand of sql supports iif() then you should be able to; if it doesn't, you can't.
0
 
kktd58Author Commented:
i am receiving an  ODBC Informix Driver syntax error (-201)when trying this. I just wasn't sure if there was some different syntax that i should be using. I guess it just does not work. Thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.