Subscribe Bookmark RSS Feed

How can i make the table from access dabase invisible?

leanpharma_gmai

Community Trekker

Joined:

Oct 28, 2011

Dear All,

Here i get a table from a access file with the following JSL and perform the further analysis like control chart. I perfer to make the table invisible after i get the control chart. Can i realize it. Thank you in advance.

dt =Open Database("DSN=MS Access Database;DBQ=F:\满易冻干坪效管理系统.accdb;DefaultDir=F:\;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;","SELECT * FROM `Q QC Internal Lead Time`");

New Column( "QC L/T", 数值型, 连续型, 格式( ":day:hr:m", 14, -1  ), 输入格式(":day:hr:m", -1), 公式( :QC报告日期 - :QC接单日期 ) );

r = dt << Select Where(:品名 == "注射用盐酸氨溴索" );

r << Colors( "Red" );

r = dt << Select Where(:品名 == "注射用盐酸克林霉素" );

r << Colors( "blue" );

dt<< Control Chart(

  Sample Label( :QC接单日期 ),

  Group Size( 1 ),

  KSigma( 3 ),

  Show Limits Legend( 0 ),

  Chart Col(

  :Name( "QC L/T" ),

  Individual Measurement( Show Center Line( 0 ), Show Control Limits( 0 ) )

  ),

  SendToReport(

  Dispatch(

  {"“QC L"},

  "2",

  ScaleBox,

  {Format( ":day:hr:m", 14, -1 ), Min( -2000000 ), Max( 11000000 ),

  Interval( "Month" ), Inc( 1 ), Minor Ticks( 0 )}

  ),

  Dispatch(

  {"“QC L"},

  "IR Chart of IM",

  FrameBox,

  {Frame Size( 574, 327 ), Grid Line Order( 1 ), Reference Line Order( 2 )

  }

  )

  )

);

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

Hello,

Give this a try:

    dt << Show Window( 0 );

Hope that helps!

Wendy
2 REPLIES
Solution

Hello,

Give this a try:

    dt << Show Window( 0 );

Hope that helps!

Wendy
leanpharma_gmai

Community Trekker

Joined:

Oct 28, 2011

WK, Thank you!