Search found 68 matches
- Thu Jan 17, 2008 6:22 am
- Forum: Need Help with Addons? (MMW4)
- Topic: SQL-Viewer 2.4 [Script] 2009-10-25
- Replies: 245
- Views: 202495
- Thu Jan 17, 2008 4:50 am
- Forum: Need Help with Addons? (MMW4)
- Topic: SQL-Viewer 2.4 [Script] 2009-10-25
- Replies: 245
- Views: 202495
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...
- Thu Jan 17, 2008 12:15 am
- Forum: Need Help with Addons? (MMW4)
- Topic: SQL-Viewer 2.4 [Script] 2009-10-25
- Replies: 245
- Views: 202495
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...
- Wed Jan 16, 2008 7:12 pm
- Forum: Need Help with Addons? (MMW4)
- Topic: SQL-Viewer 2.4 [Script] 2009-10-25
- Replies: 245
- Views: 202495
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??
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??
- Wed Jan 16, 2008 6:47 am
- Forum: Need Help with Addons? (MMW4)
- Topic: SQL-Viewer 2.4 [Script] 2009-10-25
- Replies: 245
- Views: 202495
- Wed Jan 16, 2008 4:16 am
- Forum: Need Help with Addons? (MMW4)
- Topic: SQL-Viewer 2.4 [Script] 2009-10-25
- Replies: 245
- Views: 202495
- Wed Jan 16, 2008 4:12 am
- Forum: Need Help with Addons? (MMW4)
- Topic: SQL-Viewer 2.4 [Script] 2009-10-25
- Replies: 245
- Views: 202495
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 ...
- Tue Jan 15, 2008 11:51 pm
- Forum: Need Help with Addons? (MMW4)
- Topic: SQL-Viewer 2.4 [Script] 2009-10-25
- Replies: 245
- Views: 202495
- Tue Jan 15, 2008 11:20 pm
- Forum: Need Help? (MMW4)
- Topic: Simple SQlite commands
- Replies: 1
- Views: 1618
- Tue Jan 15, 2008 10:24 pm
- Forum: Need Help? (MMW4)
- Topic: Simple SQlite commands
- Replies: 1
- Views: 1618
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\&quo...
- Tue Jan 15, 2008 8:01 pm
- Forum: Need Help? (MMW4)
- Topic: MM3 - default location of the database?
- Replies: 9
- Views: 2946
- Tue Jan 15, 2008 7:56 pm
- Forum: Need Help? (MMW4)
- Topic: MM3 - default location of the database?
- Replies: 9
- Views: 2946
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...
- Tue Jan 15, 2008 5:14 pm
- Forum: Need Help? (MMW4)
- Topic: Audting some of the meta data
- Replies: 1
- Views: 713
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...
- Thu Dec 13, 2007 8:28 pm
- Forum: Need Help? (MMW4)
- Topic: Album Artist
- Replies: 1
- Views: 828
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??
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??
- Thu Dec 13, 2007 5:56 am
- Forum: Need Help? (MMW4)
- Topic: MM wants to"sync"my ipod.I just want to view music
- Replies: 2
- Views: 798