63445_zh-CN

liliconcom

SQL - 将列表从 JSL 插入到 SQL 查询

下午好，

 

我在尝试将 JSL 中选定晶圆的列表传递到 SQL 查询时遇到问题。 目前，我可以毫无问题地引入单个批次并进行数据分析。 然而，因为我只能引入一批，所以当我想查看晶圆时，我基本上必须重新运行脚本。 从 JSL 转换为 SQL 让我很困惑，有时我会在代码中遇到错误，有时我只是得到一个空白表。 我知道当我得到一个空白表时，批次不会传递到查询中。 任何帮助将不胜感激。 我希望我在解释我的问题方面做得不错，但如果没有，请要求澄清。

 

// SQL Query  - Insert Multiple Lots from JSL input
testdata_HAY_SS_QQ_L_Data = Expr(
 "
 SELECT DISTINCT
  t1.testdate, 
  t1.wafer_id, 
  t1.wafer_number, 
  t2.rownum, 
  t2.colnum,
  t2.subrow,
  t2.subcol,
  t2.die_id, 
  t2.part_name, 
  t2.testname, 
  t2.set_id, 
  t2.trmode, 
  t2.channel, 
  t3.ts,
  t3.run_id,  
  t3.input, 
  t3.output_1a, 
  t3.output_1b,  
  t3.output_2a,  
  t3.output_2b,  
  t3.output_3a,  
  t3.output_3b, 
  t3.output_4a,  
  t3.output_4b, 
FROM tst_master  t1
 LEFT OUTER JOIN tst_dataset_header t2 
  ON  ( t2.run_id = t1.run_id )
 LEFT OUTER JOIN tst_s_params t3 
  ON  ( t3.header_id = t2.header_id )   
 WHERE (t2.testname LIKE 'test_1')
 AND (t1.wafer_number IN ("||LotListSQLString||") 
// AND (t1.wafer_number LIKE '"||SelectedLot||"') currently use to insert single wafer
 "
);
// Pulls in List of Lots
testdata_HAY_Q_LotList = Expr(
 "
 SELECT DISTINCT t1.wafer_number 
FROM tst_master  t1 
 LEFT OUTER JOIN tst_dataset_header t2 
  ON  ( t2.run_id = t1.run_id )
 WHERE t1.wafer_number RLIKE '-ATL'
 "
);

dt_LotList = Open Database( <DB_CONNECTION>, testdata_HAY_Q_LotList, "LotList", Invisible );
Summarize( LotList = By (:wafer_number ));
Insert Into( LotList, "<SELECT lot="">", 1);
Close (dt_lotlist, No Save);

// Choose Your Lot

doListChoice = expr(
 SelectedLot = LotListBox << getSelected;
 show(SelectedLot);
);

//LotListBox = ComboBox(LotList, doListChoice); // used to insert single lot

LotListBox = CheckBox(LotList, doListChoice);

win = New Window( "DataBase",
// <<MODAL></MODAL></SELECT></DB_CONNECTION>

回复：SQL - 将列表从 JSL 插入到 SQL 查询我错过了什么？