Q to dev.: Why OpenSQL errors are not handled with On Error?
Q to dev.: Why OpenSQL errors are not handled with On Error?
Please developers, this is really annoying.
You can easily do this yourself in the script. In fact it's better if you do it yourself because you built the SQL so you know what it's doing and can therefore display a more helpful error message.
Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
I think that you didn't understand me. This is exactly what I want - to handle all VBScript errors by myself. For example:trixmoto wrote:You can easily do this yourself in the script. In fact it's better if you do it yourself because you built the SQL so you know what it's doing and can therefore display a more helpful error message.
Code: Select all
On Error Resume Next
Set oIter = SDB.Database.OpenSQL("SELEC")
Oh, I thought I'd done this before without any problems. Maybe that was in MM2 and I've not re-tested in MM3 yet. 

Download my scripts at my own MediaMonkey fansite.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
All the code for my website and scripts is safely backed up immediately and for free using Dropbox.
Re: Q to dev.: Why OpenSQL errors are not handled with On Er
This should be fixed, can you confirm: http://www.ventismedia.com/mantis/view.php?id=6709
Download MediaMonkey ♪ License ♪ Knowledge Base ♪ MediaMonkey for Windows 2024 Help ♪ MediaMonkey for Android Help
Lowlander (MediaMonkey user since 2003)
Lowlander (MediaMonkey user since 2003)