5
Views
3
Comments
Solved
An expression of non-boolean type specified in a context expected, near ')'
Question

Hi All,

I have an error on my Advance Query, please check my query SQL


Thanks.

Query.txt

mvp_badge
MVP
Rank: #76
Solution

Hi Adam,

In the shared SQL query, I observed that the last statement of the where clause section is defined incorrectly (maybe you missed that) as shown below

  {UploadScorecardElement8}.[D4220]) // the Boolean/conditional expression is incomplete

instead it should be something like this

  {UploadScorecardElement8}.[D4220] <> '')


Hope this helps you!


Kind regards,

Benjith Sam

mvp_badge
MVP
Rank: #76

You're welcome, Adam :)

Glad to help you :)


Kind regards,

Benjith Sam