Skipping Values in Query but Seen in Preview

[#1]

I am pulling data from an SQL database. In the updated preview it looks good, but when I run the query, not all of the values fill in properly. Any idea what is happening with this?

Thanks,

Dave

[#2]

No, sorry! I haven't seen anything like this before. And without being able to investigate your data source and connection it is very difficult to help. I think this might be a better question for technical support (email: support@jmp.com).

[#3]

I will respond to tech support. They have already reached out. If I get a solution I will be sure and post it here.

[#4]

It was an older MySQL driver issue. Now having to use 2 drivers for MySQL. One for JMP and one for the internal database. It works!

The newer driver for JMP fixed the issue I was seeing. I went through several drivers until I finally got to one that worked. JMP also doesn't like if the driver is too new, so there seems to be a sweet spot with MySQL 5.2.