topic How do I remove the "SQL" variable from the script section of my table? in Discussions

How do I remove the "SQL" variable from the script section of my table?

waraulston — Tue, 25 Jul 2023 18:46:39 GMT

This table is created automatically by concatenating many subsets together. Each time I concatenate, an "SQL" variable shows up. I am able to delete the other scripts that come up, but I have not been able to delete this one so far. Any help is much appreciated.

Re: How do I remove the "SQL" variable from the script section of my table?

jthi — Tue, 25 Jul 2023 18:48:23 GMT

SQL is table variable not table script, so it needs different message (<< Delete Table Variable("name of variable"))

Names Default To Here(1);
dt = Open("$SAMPLE_DATA/Big Class.jmp");
dt << New Table Variable("Days", 42);
Wait(2);
dt << Delete Table Variable("Days");