Search found 68 matches

by mp3_monkey
Thu Jan 17, 2008 6:22 am
Forum: Need Help with Addons?
Topic: SQL-Viewer 2.4 [Script] 2009-10-25
Replies: 244
Views: 133437

To do all this in a script which you then can run. Do something like this: Sub RunUpdateSQL SDB.Database.ExecSQL("Update Songs Set IdMedia = Somenr") SDB.Database.ExecSQL("Update Songs Set SongPath = 'SomePath'") End Sub And then reference RunUpdateSQL in the scripts.ini file. See the Wiki and othe...
by mp3_monkey
Thu Jan 17, 2008 4:50 am
Forum: Need Help with Addons?
Topic: SQL-Viewer 2.4 [Script] 2009-10-25
Replies: 244
Views: 133437

In the meantime I recommend SQLite Spy for updates of numerical fields. If you want to update text fields it's best to wait. For text fields, for now, where I need to globally change SongPath, I can do it manually with Auto Organize Function. For numeric fields, like IDMedia, you inidcated that upd...
by mp3_monkey
Thu Jan 17, 2008 12:15 am
Forum: Need Help with Addons?
Topic: SQL-Viewer 2.4 [Script] 2009-10-25
Replies: 244
Views: 133437

Currently no DML/DDL is supported. It will be when next version of MM is released. In the meantime I recommend SQLite Spy for updates of numerical fields. If you want to update text fields it's best to wait. Actually I have, and started off with SQLite Spy and got into problems : http://www.mediamo...
by mp3_monkey
Wed Jan 16, 2008 7:12 pm
Forum: Need Help with Addons?
Topic: SQL-Viewer 2.4 [Script] 2009-10-25
Replies: 244
Views: 133437

Syntax question

I want to change IDMedia to 47 for all records.

I tried UPDATE Songs SET IDMedia ='47' in the Statement1.sql file, but it didnt work. (Error is :No SELECT or FROM keyword detected.)

What is the correct syntax??
by mp3_monkey
Wed Jan 16, 2008 6:47 am
Forum: Need Help with Addons?
Topic: SQL-Viewer 2.4 [Script] 2009-10-25
Replies: 244
Views: 133437

many thanks... installs correctly now.
by mp3_monkey
Wed Jan 16, 2008 4:16 am
Forum: Need Help with Addons?
Topic: SQL-Viewer 2.4 [Script] 2009-10-25
Replies: 244
Views: 133437

okay found it...Tools\Options\Hotkeys...
by mp3_monkey
Wed Jan 16, 2008 4:12 am
Forum: Need Help with Addons?
Topic: SQL-Viewer 2.4 [Script] 2009-10-25
Replies: 244
Views: 133437

okay I foind the missing step ...updating the scripts.ini file to enclude something like this: [ExecuteSQL] FileName=SqlViewer.vbs ProcName=SqlViewer Order=40 DisplayName=Allows SQL commands... Description=Allows SQL commands specified in Statement1.sql to be executed Language=VBScript ScriptType=0 ...
by mp3_monkey
Tue Jan 15, 2008 11:51 pm
Forum: Need Help with Addons?
Topic: SQL-Viewer 2.4 [Script] 2009-10-25
Replies: 244
Views: 133437

I installed Statement1.sql, in the MediaMonkey/Scripts directory, ran MM , and pressed CTRL+F9 but I got nothing.

Is there another step needed to enable scripts ?? ... this would be my first!
by mp3_monkey
Tue Jan 15, 2008 11:20 pm
Forum: Need Help? (mmw)
Topic: Simple SQlite commands
Replies: 1
Views: 1184

okay - figured it out - UPDATE Songs SET IDMedia ='47' But I ran into the IUNICODE problem as described in http://www.mediamonkey.com/forum/viewtopic.php?t=16897&highlight=unicode so I guess thats a brick wall for now, ie cannot make changes to the database using external editors. However, it appear...
by mp3_monkey
Tue Jan 15, 2008 10:24 pm
Forum: Need Help? (mmw)
Topic: Simple SQlite commands
Replies: 1
Views: 1184

Simple SQlite commands

For a database called TEST.DB, and a table called SONGS : 1) What is the command line syntax to change all values in the column IDMedia to 47? Is it something like REPLACE TEST.SONGS.[IDMedia] WITH 47 ?? 2) What is the substring-like command line syntax to change all references of " \\PC01\" to" C:\...
by mp3_monkey
Tue Jan 15, 2008 8:01 pm
Forum: Need Help? (mmw)
Topic: MM3 - default location of the database?
Replies: 9
Views: 1663

OKAY. Found the INI - where it is supposed to be. Panic attack is now over.
by mp3_monkey
Tue Jan 15, 2008 7:56 pm
Forum: Need Help? (mmw)
Topic: MM3 - default location of the database?
Replies: 9
Views: 1663

MM3 - default location of the database?

The documentation and FAQ still refer to the older version For MM3, on vista, where/how to I specify the location of the database? I recently moved MM.DB (away from Local\AppData) to a new location, but of course the program does not see the new location yet. I had assumed that I should be looking f...
by mp3_monkey
Tue Jan 15, 2008 5:14 pm
Forum: Need Help? (mmw)
Topic: Audting some of the meta data
Replies: 1
Views: 431

Audting some of the meta data

Just installed MM3. What a beautiful product!! Really like the new look ( especially little things like large play button! ) Minor bugs aside, the only major negative for me, was the dropping of the MS Access mdb file format. Like many others, I too wrote multiple queries and macros to facilitate se...
by mp3_monkey
Thu Dec 13, 2007 8:28 pm
Forum: Need Help? (mmw)
Topic: Album Artist
Replies: 1
Views: 617

Album Artist

In ver 2.5.5.998, I can specify seprerate values for :

a) Artist
b) Album
c) Album Artist

...but if i open the mdb file, I can only see:

a) Artist (via IDArtist)
b) Album (via IDAlbum)

Where is "Album Artist" stored in the mdb file??
by mp3_monkey
Thu Dec 13, 2007 5:56 am
Forum: Need Help? (mmw)
Topic: MM wants to"sync"my ipod.I just want to view music
Replies: 2
Views: 553

Try the the config options.... Tools / Options / PortableAudioDevice / (then select your iPod) / Configure / .... 4 tabs of options. Tab2 has a chec box for "Auto-Syncronice as asson as teh device is connected", so if you dont what that to happen, it can be deselcted - you should thne be able to jus...