nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Possible code bug with limit extraction

unknown

Hi Guys,

I am using the following JMP snippet as a part of a larger program. Problem is I get a invalid row number -1 error. When I step through the code with the debugger once and then run the code, I do not get this error and everything runs fine. What may be wrong with this code?

Accepted answers

All comments

pmroz

Try using different variable names for lsl and usl. If they are column names JMP gets very confused.

my_lsl = mysl["LSL"];
my_usl = mysl["USL"];

Regards,
Peter

mpb

What do you get when you insert show(col1, mysl) after the mysl = line? You should get something like this in the log:

col1:Column("Weight")
mysl:{LSL(65), USL(80)}

unknown

@Peter:

That worked. It's weird that JMP does not differentiate between upper case and lower case variables.

@mpb:
I was getting exactly what you showed in the log window which is why I was puzzled how the next limit extraction statement would not work.

unknown

Ok on the same lines, I get another error when the lsl or the usl is missing from the column. How can I handle this? I am ignoring the columns with missing lsl or usl with the Is missing statement:

You must insert the conditional tests before the assignments to avoid addressing a non-existent name. Try something like this...