topic Get values in the list from SQL query in Discussions

Get values in the list from SQL query

Jackie_ — Thu, 18 May 2023 18:40:05 GMT

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).
For example, save the WorkCenter sql table values in the list= {};
Any suggestions?

Thanks,

Jackie

Re: Get values in the list from SQL query

txnelson — Thu, 18 May 2023 21:26:48 GMT

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

Jackie_ — Thu, 18 May 2023 22:04:57 GMT

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

txnelson — Thu, 18 May 2023 23:24:57 GMT

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

jthi — Fri, 19 May 2023 07:04:33 GMT

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)