Skip to Content (Press Enter)
2020-11-13 06-20-57
Kane Loony
178Views
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
22 Dec 2020
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP
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
22 Dec 2020
Copy Link
2020-11-13 06-20-57
Kane Loony

Hi Benjith,


Thanks for the answer, I try and work


Best Regards,

Adam Sakti

0
0
22 Dec 2020
Copy Link
2021-03-18 21-03-15
Benjith Sam
 
MVP

You're welcome, Adam :)

Glad to help you :)


Kind regards,

Benjith Sam

0
0
22 Dec 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.