Based on prior communication, IIF() shold be okay as long as the 2nd and 3rd args are the same type.
I am having issue with a db. Here is the message.
UCanAccess>routine signature not found for: PUBLIC.IIF(INTEGER,VARCHAR,VARCHAR)
This is consistent in 2.0.9.3 and 2.0.9.5.
PS, tysm for your project. Very helpful.
I was able to recreate your issue by changing a field in an Access table from Yes/No to Number (Long Integer).
Yes/No
Number (Long Integer)
If you have Yes/No values in an integer field (as -1 and 0, respectively) then you can use
SELECT IIf(CBool(integerField), 'trueValue', 'falseValue') AS whatever ...
Log in to post a comment.
Based on prior communication, IIF() shold be okay as long as the 2nd and 3rd args are the same type.
I am having issue with a db. Here is the message.
This is consistent in 2.0.9.3 and 2.0.9.5.
PS, tysm for your project. Very helpful.
I was able to recreate your issue by changing a field in an Access table from
Yes/NotoNumber (Long Integer).If you have Yes/No values in an integer field (as -1 and 0, respectively) then you can use