SQL Tree
By: fbuser
Version: 1.1.0 (archived)
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 processor architecture: x86 32-bit.
Works with foobar2000 v1.3 and newer
Links
No download available.
View version history
View latest version and component description
Documentation
Discussion
How to install a component?