topic Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1) in Discussions

JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

PearsonEagle535 — Sat, 10 Jun 2023 23:47:23 GMT

Hi,

I have encountered this problem when I run a old script on JMP 15. Anyone can help me to solve this problem? Thank you in advance!

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

txnelson — Tue, 19 Apr 2022 17:08:27 GMT

Thid error occurs when the argument to the function is blank. The example below will throw that error:

r="";
current data table(r);

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

Thierry_S — Tue, 19 Apr 2022 17:11:24 GMT

Hi,

Could you share the portion of the script that triggers the error?

One obvious but unlikely issue might be that you do not have any table opened when you invoke the Current Data Table function.

Also, if you want to define a specific table, use the Data Table ("name") function instead of Current Data Table.

Best,

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

Georg — Tue, 19 Apr 2022 22:15:58 GMT

You may want to activate "Show embedded Log" in the Script Window (by right clicking, or setting this in the preferences.

Then the Log tells you at which Line this error occurs.

You can check the prerequisites (if variables are populated with the expected values) by hovering over the variable name, it will show the value. The snippet I borrowed from @txnelson - Thanks.

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

StarfruitBob — Fri, 06 May 2022 21:06:28 GMT

I also get this error. The log shows:
******
Argument must contain data table reference in access or evaluation of 'Current Data Table' , Current Data Table/*###*/(dt1)

at line 1 in Script for MyData

******

Line 1 in my script is:

Current Data Table(dt1);

I'm running the script on a table that's open. It's the only data table open. Any ideas?

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

StarfruitBob — Fri, 06 May 2022 21:24:29 GMT

Interesting, for my specific usage I was able to leave Current Data Table() empty to successfully run the command with the desired output. My guess is what if the table you intend to run this script on is on top, that you should be able to leave the argument empty.

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

danschikore — Sat, 07 May 2022 02:32:14 GMT

When you run Current Data Table() with no argument, it returns a reference to the current table. When called with an argument, it should be a reference to an open data table. Here is another example that will give the error in question, on the second call to Current Data Table(dt1):

dt1 = Open("$SAMPLE_DATA/Big Class.jmp");
Show(Type(dt1));            // "Table"
Show(IsEmpty(dt1));         // 0
Current Data Table(dt1);    // ok
Close(dt1);
Show(Type(dt1));            // "Table"
Show(IsEmpty(dt1));         // 1
Current Data Table(dt1);    // gives error

As mentioned by @Georg above, after running the script you can hover over variables in the script to get some information, or use the embedded log to query the values. If you highlight the dt1 variable and evaluate (run) the script, the log will display:

Data Table( "UnknownTable" )

In the example above, I also use IsEmpty(dt1) to show one way that you can detect with JSL that the variable refers to an object that no longer exists.

topic Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/*###*/(dt1) in Discussions

JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/*###*/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/*###*/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/*###*/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/*###*/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/*###*/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/*###*/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/*###*/(dt1)

topic Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1) in Discussions

JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)

Re: JMP alert: Argument must contain data table reference in access or evaluation of 'current data table', current data table/###/(dt1)