Overview | News | Windows | macOS | Android | iOS | Audio Formats | Components | Encoder Pack | Screenshots | Help & Support | Developer | Old Versions | Other Projects
SQL Tree
By: fbuser
Version: 1.1.0 (archived)
No download available.
Change log:
- fixed: scrollbars were not placed to the very edge of the panel
- fixed: inserting nodes at the beginning of an existing query definition results in random colors for the node
- fixed: text background for an unselected node was drawn larger than for a selected node
- fixed: parallel use of playist actions in the tree and querying of the column metadb_handle led to wrong results for the playlist action
- fixed: cross joins didn't work for the virtual tables
- fixed: parameters, which were used during the creation of a virtual table were ignored after a reconnect to the database
- fixed: execution time in SQL Tree Console was not reset after close
- changed: no action will be executed when left click on tree item when shift is pressed
- changed: no action will be executed when middle click on tree item when shift or ctrl is pressed
- changed: execute button actions on button up instead of button down
- changed: use "SQL Tree playlist" as default name for target playlist actions, if target playlist name is empty
- added: support undo for playlist changes
- added: possibility to define context specific icons and colors for query result nodes
- added: context menu entry "Properties" for queries.
- added: action "Choose from menu"
- added: action "Send to Library Viewer Selection playlist"
- added: support for selection holder
- added: possibility to cut/copy/paste (+ drag/drop) query+folder nodes
- added: SQL functions playing_playlist(), active_playlist()
- added: SQL functions tf_playing_item(tf_expression), tf_focus_item(playlist_index,tf_expression), tf_focus_item_pn(playlist_name,tf_expression)
- added: SQL function file_exists(file)
- added: predefined fields for the virtual Playlist table: item_is_playing, item_has_focus, item_is_selected
- added: possibility to update tags with the SQL UPDATE statement
- added: possibility to add or remove items from a playlist with the SQL INSERT or DELETE statement
- added: use automatic index on all columns, which don't have the column type "Predefined" and also for the playlist column playlist_name, playlist_index and playlist_item.
- added: the SQL Tree console remembers the last executed query after closing and reopening it
- other: upgrade to SQLite 3.7.17
Supported system: Windows 32-bit.
Works with foobar2000 v1.3 and newer
Links
View version history
View latest version and component description
Documentation
Discussion