SQLite query returns out of date info
Posted: Wed May 08, 2019 3:40 pm
Hi,
I've set up an ODBC connection to my MM.DB so that I can make my own reports, but I notice that the data it returns is missing music added less than 21 days ago. My ODBC connection is pointing to a MM.DB dated 7/5/19, but it doesn't contain anything added after 18/4/19 in it. I've searched to see if there's a different MM.DB anywhere, but the ones I've found are much older so I'm sure I'm pointing to the right one (C/Users/Me/AppData/Roaming/Mediamonkey). I've run a Trixmoto script (Custom Report Auto) to report from MediaMonkey and it shows all songs.
I don't know why this is happening. I've only just set the connection up so it might be something I've done wrong, but I don't know what else to test. I'm using Power BI to make my reports, if that's any help.
I've set up an ODBC connection to my MM.DB so that I can make my own reports, but I notice that the data it returns is missing music added less than 21 days ago. My ODBC connection is pointing to a MM.DB dated 7/5/19, but it doesn't contain anything added after 18/4/19 in it. I've searched to see if there's a different MM.DB anywhere, but the ones I've found are much older so I'm sure I'm pointing to the right one (C/Users/Me/AppData/Roaming/Mediamonkey). I've run a Trixmoto script (Custom Report Auto) to report from MediaMonkey and it shows all songs.
I don't know why this is happening. I've only just set the connection up so it might be something I've done wrong, but I don't know what else to test. I'm using Power BI to make my reports, if that's any help.