6
I keep the SQL Error window active and I kept the Foobar2K Console window open and I cleared it after I did each of the following:
I can execute the Batch in the SQL Lite Console without an error.
I can execute the Query in the SQL Lite Console without an error. It returns the expected number of rows. It also returns all of the paths when I add it to the select statement.
The Query successfully Validates
The Tree is named Bad Fields Forum Test. When I click it I get the progress bar and the playlist populates as expected.
Console:
[foo_uie_sql_tree] 21:01:40.488: Get tracks for query node "Bad Fields Forum Test" ...
[foo_uie_sql_tree] 21:01:40.492
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Query node SQL:
SELECT path,
subsong
FROM BadFieldTable
ORDER BY Node1, album, discnumber, tracknumber COLLATE NaturalNoCase
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
[foo_uie_sql_tree] 21:01:40.800: Get tracks for query node "Bad Fields Forum Test": 0:00.312742
When I click on the 1st sub-node, composers (67), nothing's added to the playlist.
[foo_uie_sql_tree] 21:14:54.386: Get tracks for query node "Bad Fields Forum Test" ...
[foo_uie_sql_tree] 21:14:54.387
>>>>>>>>>>>>>>>>>>>>>>>>>>>>>
Query node SQL:
SELECT path,
subsong
FROM BadFieldTable
WHERE CAST(Node1 AS TEXT) = 'composers (67)'
ORDER BY Node1, album, discnumber, tracknumber COLLATE NaturalNoCase
<<<<<<<<<<<<<<<<<<<<<<<<<<<<<
[foo_uie_sql_tree] 21:14:54.387: Get tracks for query node "Bad Fields Forum Test": 0:00.002451
Let me know if you need me to do anything else.
Unrelated Topic: In Playback Statistics, do I have to use Automatically Synchronize File Tags to use Played Count in SQL Tree?