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.
SongsDB5.SDBApplication in vb.net
Moderators: jiri, drakinite, Addon Administrators
Re: SongsDB5.SDBApplication in vb.net
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
See this for details: https://www.mediamonkey.com/wiki/Contro ... plications