Boolean value for Boolean column in SQL Widget

Johnson Lim

Solved

Question

Hi,in my SQL , the where clause {SRAction}.[IsActive] need to be always true.The code is as per below.

SyntaxEditor Code Snippet

{SRAction}.[IsActive]=True

However, it i hits error as per below

By removing the where clause, the SQL is running fine.

Does anyone has idea on this?Help !!

10 Jan 2018

Shashi Kant Shukla

Solution

Hi Johnson,

You need to write where condition like below:

where {SRAction}.[IsActive]=1

Regards

-SK-

10 Jan 2018

Johnson Lim

Thanks Shashi

10 Jan 2018

Shashi Kant Shukla

You are welcome !

Regards

-SK-

10 Jan 2018

Kilian Hekhuis

MVP

I want to add that for such a simple query, you should use an Aggregate, not a SQL!

10 Jan 2018

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.