Q to dev.: Why OpenSQL errors are not handled with On Error?

Download and get help for different MediaMonkey for Windows 4 Addons.

Moderators: Peke, Gurus

ZvezdanD
Posts: 3265
Joined: Thu Jun 08, 2006 7:40 pm

Q to dev.: Why OpenSQL errors are not handled with On Error?

Post by ZvezdanD »

Please developers, this is really annoying.
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto »

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.
ZvezdanD
Posts: 3265
Joined: Thu Jun 08, 2006 7:40 pm

Post by ZvezdanD »

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.
I think that you didn't understand me. This is exactly what I want - to handle all VBScript errors by myself. For example:

Code: Select all

On Error Resume Next
Set oIter = SDB.Database.OpenSQL("SELEC")
This will display unneeded error message, even if there is On Error in the front of the wrong line. Other VBScript errors are handled with On Error Resume Next without a problem. Maybe I should use a term "catched" instead of "handled". Sorry for my bad English.
trixmoto
Posts: 10024
Joined: Fri Aug 26, 2005 3:28 am
Location: Hull, UK
Contact:

Post by trixmoto »

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.
ZvezdanD
Posts: 3265
Joined: Thu Jun 08, 2006 7:40 pm

Post by ZvezdanD »

trixmoto wrote: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. :-?
Actually, it is same behavior in MM2, as in MM3. :( I just tried it.
Lowlander
Posts: 58344
Joined: Sat Sep 06, 2003 5:53 pm

Re: Q to dev.: Why OpenSQL errors are not handled with On Er

Post by Lowlander »

This should be fixed, can you confirm: http://www.ventismedia.com/mantis/view.php?id=6709
Post Reply