View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0006709 | MMW v4 | Framework: Scripts/Extensions | public | 2010-11-18 00:49 | 2014-10-04 15:58 |
| Reporter | zvezdan | Assigned To | |||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | feedback | Resolution | reopened | ||
| Fixed in Version | 4.0 | ||||
| Summary | 0006709: OpenSQL & CreateFolder errors are not handled with On Error | ||||
| Description | Almost all errors could be handled using On Error, but not OpenSQL and CreateFolder which always displays error dialog box. | ||||
| Steps To Reproduce | On Error Resume Next Set oIter = SDB.Database.OpenSQL("SELEC") or On Error Resume Next SDB.Tools.FileSystem.CreateFolder "C:\Temp\P5 ...\Test\" | ||||
| Additional Information | http://www.mediamonkey.com/forum/viewtopic.php?f=2&t=30420 http://www.mediamonkey.com/forum/viewtopic.php?f=6&t=40369 These dialog boxes is really irritating and cannot be avoided. It would be nice if you resolve that somehow, especially the one with OpenSQL. | ||||
| Tags | No tags attached. | ||||
| Fixed in build | 1347 | ||||
| has duplicate | 0005782 | new | MMW Wishlist | OpenSQL & CreateFolder errors are not handled with On Error Resume Next |
|
|
Fixed in build 1329. |
|
|
Great, tested with 1343 and this is finally resolved. However, I need to ask, why we need to wait so long for the program response? There are 21 seconds with the blocked program between the error line and the next resumed one. |
|
|
You are right. There is really 20 sec. delay before throwing the error (tested with SQLViewer script) Fixed in build 1345 |
|
|
Tested just now in 1346. OpenSQL doesn't return any error code (Err = 0) when there is an error in execution, but it should. By the way, I forgot to say that you should do the same thing with the AddTracksFromQuery method which still doesn't work with the On Error statement. I didn't try yet QuerySongs and ExecSQL - they all should have the same behavior with the On Error statement. |
|
|
Test code: On Error Resume Next Set oIter = SDB.Database.OpenSQL("SELEC") If Err Then MsgBox Err.Description |
|
|
All is fixed in build 1347. |
|
|
Confirmed in 1348. Thanks so much for this. |
|
|
CreateFolder error still cannot be handled with On Error. |
