632905_en-US

liliconcom

Get values in the list from SQL query

Hi,

 

Is there way I could insert the column values in the list than jmp table?

I 'm trying to write a JSL code to query data from database and I want to store the values from the SQL table into a variable list (not in the JMP table). Any suggestions?

Thanks,

Jackie

Automation and ScriptingData AccessRe: Get values in the list from SQL query

The simplest thing to do, would be to extract the column of data into a JMP data table(it can be an invisible table if desired) and then to use

ValueList = :column name << get values;

to move the column of data from the data table to a list, and then simply close the data table.

 

Re: Get values in the list from SQL query

Hi Jim, That's what I am doing rn, but the problem is it will keep generating multiple tables every time the query is run.
Thanks!

Re: Get values in the list from SQL query

Your JSL should be able to delete all of those data tables very quickly, so they will not create any issues for the user.

Re: Get values in the list from SQL query

1. Perform the query and get table as invisible/private

2. Get values from the table

3. Close the table

(4. Write a function to do all this if you repeat it many times with different queries)