85875_en-US

liliconcom

JSL create a Query dialog

hello.

my project is to create a Query dialog with JSL.

i would like to make a dialog box  where i can put a certain number of Lots  and put this  values in a variable

so.. i found the option "COL SPAN BOX"... seems useful.....but work only if i put one lot Number.

 

here the rudimental script i builted:

 

 

test = New Window( "lots query",
   <<MODAL></MODAL>

 

 

 

but my scope is to have the possibility to insert an undefinite numbers of lots and get the values for all of them.

how i can modify my code (or indicate me some other way) to get my scope?

 

 thanks in advance

Gianpaolo

Re: JSL create a Query dialogYeah that's native. You don't even need to do anything. Just copy from excel and when you paste it should paste properly.Re: JSL create a Query dialog

woww!!! very nice script Vince

the first solution is the one  closest to my query dialog Query!!!!

 

 

if now i have a batch of lots.. and i want to make copy /past in the dialog box.. and get the values do you think is possible?  

 

Re: JSL create a Query dialog

This I think would work for you. 

 

test = New Window( "lots query", <<MODAL></MODAL>

But if you can query the database in advance you can select only the lots that actually exist with something like this

 

//real query would be an open database call
//dt = open database("FAKE DATABASE", 
// "SELECT DISTINCT LOT", 
// "Lot Numbers"
//);

//this is just a fake table for example
dt = New Table("Lot Numbers", 
 New Column("Lot", "character", Set Values({"A12", "B36", "C465", "D234"}))
);

test = New Window( "lots query", <<MODAL></MODAL>