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 ...

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 ...

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 ...

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??

many thanks... installs correctly now.

okay found it...Tools\Options\Hotkeys...

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 ...

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!

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 ...

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 ...

OKAY. Found the INI - where it is supposed to be. Panic attack is now over.

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 ...

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 ...

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??

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 ...