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

Community Tip - You can subscribe to a forum, label or individual post and receive email notifications when someone posts a new topic or reply. Learn more! X

Sql query result not returning null instead returning ---

svisveswaraiya
17-Peridot

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 3

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

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
23-Emerald II
(To:mneumann)

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

Top Tags