Sql query result not returning null instead returning ---

[svisveswaraiya]

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.

[zyuan1]

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

[mneumann]

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.

[slangley]

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