topic Re: How do I use the include function to run a separate script which uses an open data table? in Discussions

How do I use the include function to run a separate script which uses an open data table?

PowerOx327 — Sat, 10 Jun 2023 23:51:59 GMT

Hi all,

I've created a script which pulls from SQL and creates a data table as so:


Names Default To Here( 1 );
dtFROMSQL = Execute SQL(
databaseConnectionHandle,
"SELECT HEIGHT, WEIGHT FROM Bigclass",
"NewTable"
);
Include(filepathforsecondscript.jsl);

And then I have another script in my personal folder which adds a column to the data table:

Current Data Table( dtFROMSQL );
dt << New Column( "X", Formula( Random Uniform() ) );

I use an Include function in the first script to run the second script.

My problem is that when I try to run it the second script does not detect the data table created in the first script, I get an error like so:

Name Unresolved: dt in access or evaluation of 'dt' , dt/*###*/

Any way to get my second script to detect the data table created in the first script?

Re: How do I use the include function to run a separate script which uses an open data table?

vince_faller — Thu, 28 Jul 2022 04:07:04 GMT

Is it not because you're doing

dt << New Column( "X", Formula( Random Uniform() ) );

instead of

dtFROMSQL << New Column( "X", Formula( Random Uniform() ) );

dt doesn't exist in your top script.

Re: How do I use the include function to run a separate script which uses an open data table?

PowerOx327 — Thu, 28 Jul 2022 05:00:58 GMT

Yeah it worked. Thanks!

Re: How do I use the include function to run a separate script which uses an open data table?

Mark_Bailey — Thu, 28 Jul 2022 12:45:17 GMT

The first script declares all variables to be in the Here space, local only to that script. The second script uses a variable with the same name, but it is not the same variable. It is either a global variable with the same name or another one defined in the Here name space of the second script.

Also, you define the current data table, but not the value stored in the variable dt.