Error for JMP 15 users that JMP 16 PRO users don't have with querying a table with JMP addin Script
I have JMP 16 but and have no issues with my JMP addin query working. JMP 15 users have an error when running the below and don't get the table.
Open Database(
"DSN=PI SQL Connection Lab;Description=PI SQL Connection Lab;UID=;Trusted_Connection=Yes;APP=JMP;WSID=SFX-5GCN2M1;DATABASE=LabData",
"select t.* from (select t.*, row_number() over (partition by SiteID, TimeStamp order by (sele
...