Skip to main content
S
svisveswaraiya_2859881-Visitor
1-Visitor
November 10, 2018
Question

Sql query result not returning null instead returning ---

  • November 10, 2018
  • 2 replies
  • 1483 views

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

2 replies

Z
zyuan15-Regular Member
5-Regular Member
November 12, 2018

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

M
mneumann16-Pearl
16-Pearl
November 12, 2018

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.

S
slangleyCommunity Manager
Support
December 5, 2018

Hi @svisveswaraiya_285988

 

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

Terms & ConditionsAccessibility statement