Instantly extract effect sizes, F-ratios, and FDR-adjusted p-values from your models with the Calculate Effects Sizes extension, available now in the JMP Marketplace!
New to JMP? Join us Sept. 23-24 for the Early User Edition of Discovery Summit, tailor-made for new users. Register now for free!
Your voice matters! Tell us how you prefer to receive JMP updates, so we can tailor our communication to your needs. Take short survey.

Discussions

Solve problems, and share tips and tricks with other JMP users.

Level IV

Created: Jun 9, 2023 10:30 AM | Last Modified: Jun 11, 2023 4:49 AM (1096 views)

Hi ,

I used JMP DATAbase Query to query data from tables. the same query worked find until today it suddenly complains of issue of converting char to int. I'm not sure why it worked before and nothing has changed, but now not it is not working. So I started to work on the custom query to find a way to add script to convert. This is my first time with the custom sql query.

how can I convert the t2.[tools] to int in this section of the query? I tried convert() and cast() on it but failed. can someone help?

select

t14.[value] AS [value 1]
LEFT OUTER JOIN [xxx.[xxx_table] t14
ON ( t2.[tools] = t14.[value_id])

0 REPLIES 0

Discussions

Failed to convert varchar value ro datatype int in query (query worked before but now not)

Recommended Articles