I have a JSL script that will sucessfully pull data on the first run after I open JMP, but if I try to run the script again with new parameters in the SQL query for a new set of data, it will act like it is connecting and pulling data, but I get no table in JMP. There are no errors in my log. Sometimes if I change the name of the output table ("MyTable") and what I called the database connection ("ftdb"), it will work again, but it seems odd. I have Delete Symbols (); at the top to clear everything? Is there something else that I need to clear? If I close JMP and re-open it works fine again, but that seems sub-optimal.....
ftdb = Create Database Connection ("DSN=zzzzz;UID=yyyy;PWD=xxxx");
dtmoves = Execute SQL (ftdb, sql, "MyTable");
Close Database Connection (ftdb);
This might be one to work through with JMP Technical Support (email@example.com). But two questions:
1. What version of JMP is this?
2. Who is the database vendor? (SQL Server, MySQL, Oracle, etc.)