SongsDB5.SDBApplication in vb.net

To discuss development of addons / skins / customization of MediaMonkey.

Moderators: jiri, drakinite, Addon Administrators

bensynnock
Posts: 17
Joined: Thu Oct 11, 2012 3:23 pm

SongsDB5.SDBApplication in vb.net

Post by bensynnock »

I've finally managed to get the MM5 reference to open in Visual Studio 2022, and now am converting my application to use the new SongsDB5, instead of the MM4 SongsDB. I understand that some of the functionality has changed, but all I'm interested in doing is running SQL queries, updating a custom field in the database, and adding playlists. The documentation points to here: https://www.mediamonkey.com/wiki/SDBApplication , which shows the SDBSongIterator method, however, I am unable to use the statement:

Dim qd As isdbsongiterator - I see some other ISDB members here but not the songiterator as before,

and I also have:

Dim SDB1 As SongsDB5.SDBApplication (which creates an object for accessing the database)
and then the querysongs:
qd = SDB1.Database.QuerySongs("AND Songs.LastTimePlayed>=" & todaydays - m.base)

(I then use qd.eof to loop through the database adding songs to a songslist object)

qd = SDB1.Database. - no longer shows querysongs as a method


If these functions are no longer available, it appears that the wiki hasn't been updated, or if they should be available are they not working, or am I doing something wrong? Is there an alternative way to execute the SQL queries?

Any assistance would be gratefully received.
Ludek
Posts: 4958
Joined: Fri Mar 09, 2007 9:00 am

Re: SongsDB5.SDBApplication in vb.net

Post by Ludek »

QuerySongs is no longer supported on SongsDB5.SDBDatabase, there are only methods like ExecSQL and OpenSQL, but amost everything can be performed using runJSCode

See this for details: https://www.mediamonkey.com/wiki/Contro ... plications
Post Reply