cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Sql query result not returning null instead returning ---

Highlighted

Sql query result not returning null instead returning ---

Hi,

When I execute a simple sql query,

"select CabExitTime from ProcessTime where JobNumber = [[Job]] "

I am getting result as "---"

My base type is infotable.

Please help me to know where I have gone wrong.

 

Thanks,

V Shalini.Fault.pngsql.png

3 REPLIES

Re: Sql query result not returning null instead returning ---

That could mean Null in infotable result, you can assign this result to a Grid widget, and see what you get.

Re: Sql query result not returning null instead returning ---

It seems like the MS SQL query already returns NULL.

This is the result ThingWorx receives as well.

 

I'm not sure about the query itself, but you could try unquote the number.

Is there any value in the table for this process number if you look it up directly? Just opening the table, viewing it - not with a query.

Re: Sql query result not returning null instead returning ---

Hi @svisveswaraiya-

 

If one of the previous responses allowed you to solve your issue, please mark the appropriate one as the Accepted Solution for the benefit of others who may experience the same issue.  Or if you have found a different solution, we would love for you to post it here and mark that as the Accepted Solution.

 

Regards.

 

--Sharon