SQL-Viewer 2.4 [Script] 2009-10-25

Bex · Post by **Bex** » Tue Feb 05, 2008 5:51 pm

Thanks!

Glad you found it useful.

nynaevelan · Post by **nynaevelan** » Tue Feb 19, 2008 9:41 pm

Hi Bex:

When you get a chance, can you look at this script? There seems to be some conflict occurring with it and the SQL Viewer, maybe you have an idea or two how to resolve it.

Nyn

Bex · Post by **Bex** » Wed Feb 20, 2008 11:43 am

I'm a bit busy now and I don't know when I'll get the time...

Teknojnky · Post by **Teknojnky** » Mon Apr 14, 2008 4:17 pm

Is there a safe way to clear the 'covers' table?

I want to clear only the DB covers and have MM re-detect embedded/external art.

edit

well it seemed pretty simple actually...

Code: Select all

DELETE from Covers

Make sure you backup your database before doing that, and re-scan after to re-import existing art!

Bex · Post by **Bex** » Mon Apr 14, 2008 5:01 pm

Yeah, it's almost to simple to delete data from a table..

Good idea. I think I'll do exactly that myself.

Owyn · Post by **Owyn** » Fri Apr 18, 2008 8:16 pm

Thanks for the script. Very useful.

Bex · Post by **Bex** » Fri Apr 18, 2008 8:22 pm

Thanks Owyn!

Bex · Post by **Bex** » Wed Apr 30, 2008 8:04 pm

Script is updated
Ver 2.1 (2008-04-30) [MM3 only]

What's new?
- Change the window to a floating window
- Enlarged the <History> and <Saves> dropdowns dramatically (They were annoyingly short.)
- Changed numbers of saved history queries to 200
- Fixed so "history saves" older than last 200 are automatically deleted
- Added more buttons, [*], [COUNT(*)], [ORDER BY]

Enjoy!
/Bex

MDominik13 · Post by **MDominik13** » Wed Apr 30, 2008 8:39 pm

Thanks for the great script. It has been a huge help to me in writing my own scripts and doing basic DB maintenance.

I do have one problem though. When my query results in an error, the error message gets stuck behind the query window. I worked around the problem by disabling the StayOnTop option for the form. Not sure if this is the right thing to do or if I'm doing something wrong.

Bex · Post by **Bex** » Thu May 01, 2008 4:23 am

Thanks!

That doesn't happen for me. Does it happen with the latest version as well?
What version of MM do you use?

MDominik13 · Post by **MDominik13** » Thu May 01, 2008 9:42 am

I just installed your latest script and I'm using MM 3.0.3.1164.

I wish I could figure out how to reproduce it. I just set StayOnTop back to true and now it's not happening (it happened like 90% of the time before). Anyhow, I'll let you know if I can reproduce it and, if so, how.

Teknojnky · Post by **Teknojnky** » Thu May 01, 2008 10:03 am

perhaps move the save/delete buttons under the indent control, and lock the lists to the right side of the form so the drop down's expand/contract with the form?

Bex · Post by **Bex** » Thu May 01, 2008 11:46 am

@MDominik13,
Yeah, I think I had that problem too but I changed something so it vanished, I forgot to update the script here though.

@Tekno,
Good idea, it'll be fixed soon.

Bex · Post by **Bex** » Thu May 01, 2008 12:16 pm

Script is updated
Ver 2.1.1 (2008-05-01) [MM3 only]

What's new?
- Fixed some layout issues (thanks to tekno)
- Improved RemVBS function

Enjoy!
/Bex

Bex · Post by **Bex** » Thu May 08, 2008 8:09 am

Script is updated
Ver 2.2 (2008-05-08 ) [MM3 only]

What's new?
- Added DropDown which adds data to the SQL-Window from the selected song in MM

Enjoy!
/Bex