你好，
我正在使用 File>Database>Query Builder 方法連接到一個 excel 文件並創建一個表。 我可以使用 jmp 腳本關閉表，但連接保持活動狀態並為其他用戶鎖定 excel 文件。 如何通過 jmp 腳本斷開連接？ 我可以手動通過文件>數據庫>打開>斷開連接，但我想在運行腳本中自動執行此操作。
這是查詢代碼：
RedBinMain = New SQL Query(
Version( 130 ),
Connection(
"ODBC:DSN=Excel 12.0;DBQ=I:\Engineering\Data\JMPTempData\redbindownload_JMPTMP.xlsx;DefaultDir=I:\Engineering\Data\JMPTempData;DriverId=1046;FIL=excel 12.0;MaxBufferSize=2048;PageTimeout=5;"
),
QueryName( "RedBinMain_beta" ),
Select(
Column( "RBNbr", "t1" ),
Column( "DMR", "t1" ),
Column( "Date_Entered", "t1" ),
Column( "Initiator", "t1" ),
Column( "Location", "t1" ),
Column( "AssignedPerson", "t1" ),
Column( "Problem", "t1" ),
Column( "USI_PN", "t1" ),
Column( "Customer", "t1" ),
Column( "Disposition", "t1" ),
Column( "LastUpdatedDate", "t1" ),
Column( "Cause", "t1" ),
Column( "Classification", "t1" ),
Column( "Defect_Code", "t1" ),
Column( "BrokenSubMenu", "t1"),
Column( "BrokenSubMenu_1", "t1"),
Column( "Dimensional_Code", "t1" ),
Column( "Notes", "t1" ),
Column( "Assignable_WorkCell", "t1" ),
Column( "DispositionerInvestigator", "t1" ),
Column( "ScrappedQuantity", "t1" ),
Column( "PreEtch", "t1" ),
Column( "PostEtch", "t1" )
),
From( Table( "RedBinMain_beta", Alias( "t1" ) ) )
) << Run Foreground;
我嘗試了下面的代碼但沒有運氣
close database connection(RedBinMain);
我錯過了什麼？
這是使用 ODBC 驅動程序“Excel 12.0”將連接顯示為“已連接”的位置
