1-Visitor

Question

Sql query result not returning null instead returning ---

3 replies
1495 views
Translate All

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.

Z

zyuan1

5-Regular Member

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

Translate

M

mneumann

16-Pearl

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.

Translate

S

slangley

Support

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

Translate

Sql query result not returning null instead returning ---

3 replies

Windchill Satisfaction Survey

Take the Survey ↗

Windchill Satisfaction Survey

Take the Survey ↗

Sign up

Please use your PTC eSupport account.

Welcome to the PTC Community

Please use your PTC eSupport account.