Kane Loony
Rank: #33689
5Views
3Comments
Solved
An expression of non-boolean type specified in a context expected, near ')'
Question
SQL

Hi All,

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


Thanks.

Query.txt

0
0
on 2020-12-22
Copy link to comment
Benjith Sam
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

1
0
on 2020-12-22
Copy link to comment
Benjith Sam
mvp_badge
MVP
Rank: #76

You're welcome, Adam :)

Glad to help you :)


Kind regards,

Benjith Sam

0
0
on 2020-12-22
Copy link to comment