topic Re: Reopening saved Querys in Discussions

Reopening saved Querys

BadgerXX — Fri, 01 Mar 2024 14:16:10 GMT

Hello,

Problem is following:

1. I am making query using query builder in JMP17.

2. Query pulling data from particular tables from SQL database. Pulling data and creating from it JMP table works correctly.

3. Query is saved as a .jmpquery

4. During reopening previously saved query, at each time JMP is unable to find source table and below comment appears.

In effect I need to made query from basis at each time.

Does anybody had this problem? Do you know solution?

Re: Reopening saved Querys

jthi — Tue, 12 Mar 2024 20:51:13 GMT

seems to have similar issue but there is no solution.This might be something you want to contact JMP support to assist you with but I will tag @Jed_Campbell as he did post to that other question (could database structure have changed?) .

Re: Reopening saved Querys

Jed_Campbell — Tue, 12 Mar 2024 21:07:07 GMT

Another thing perhaps worth checking is if the name of your connection has changed. This would likely mean a mismatch between the name of the connection in JMP and the name of the connection in your ODBC Data Sources app (assuming you are in Windows).