ATTACH DATABASE 'profile/configuration/foo_uie_sql_tree.db' AS sqltree;


DROP TABLE IF EXISTS   sqltree_master;
CREATE TEMPORARY TABLE sqltree_master AS
SELECT   type
       , name
       , tbl_name
       , rootpage
       , sql
    FROM sqltree.sqlite_master
ORDER BY type
       , name
         ;


DETACH DATABASE sqltree;


SELECT *
  FROM sqltree_master

Preferences window cut.

EDIT: Forgot to say, that I use Windows 11 at 125% DPI Scaling. With 100% its ok.

See: https://hydrogenaud.io/index.php/topic,116045.msg1010332.html#msg1010332

Quote from: grimes on 2023-04-24 07:20:29

Preferences window cut.

EDIT: Forgot to say, that I use Windows 11 at 125% DPI Scaling. With 100% its ok.

See: https://hydrogenaud.io/index.php/topic,116045.msg1010332.html#msg1010332

See also: https://github.com/stuerp/foo_midi/issues/3

Firstly, I'm still crashing when creating a new playlist by sending tracks to one, opening up the SQLite console, and executing SELECT * FROM Playlist.

Is the total of open playlists somehow a factor?

That table seems to no longer exist,

ATTACH fb2k_profile_path()||'\configuration\foo_uie_sql_tree.db' AS sqltree;

Third issue: in the properties window, I have to press the OK button twice when making changes to the MediaLibrary or Playlist tables. The first press acts like pressing Apply.

In the SQL Tree Edit query node Action tab, a previously set value for Target playlist appears blanked out if there is not currently a playlist of that name open in foobar. Pressing OK will overwrite the previous value with a blank one.

I'd love for the scrollbars to be dark in dark mode.

Fixed.

CREATE VIRTUAL TABLE temp.csv USING vsv(filename='profile/moodflag/csv/custom_tags_dflt.csv'
                                      , header=1
                                        );


ATTACH DATABASE (SELECT fb2k_profile_path()
                     || '/configuration/foo_sqlite.db'
                        )
             AS sqlitedb
                ;

I can't put a SELECT fb2k_profile_path() in the first statement like I can in the second, since I seem to have left SQLite inside those parentheses of the vsv() function. Is there some slick bit of C I can stick in there to do the same thing?

CREATE VIRTUAL TABLE temp.csv USING vsv(filename=fb2k_profile_path()||'\moodflag\csv\custom_tags_dflt.csv'
                                                                   , header=1
                                                                    );

ATTACH DATABASE fb2k_profile_path()||'\configuration\foo_sqlite.db' AS sqlitedb;

I changed my code to that, and it fails now at the first line with a SQLite Error.

when I execute my query in console: after execution 5000 row limit is reached, but in [advanced] the query node limit is 100000 set.
Is there something wrong or is this only in SQLlite console view?

s a Title Format function that would allow one to specify a SQL Select statement, and then get back the query result. 

Hi, I just installed this component for the very first time. I wanted to play around with the lookup tables, but all the buttons in the lookup tables dialog are disabled.

This should not be. Could you please post a screen shot of your dialog?

See the image attached.

In the lookup table dialog only the name and the key of the lookup table are specified.

I managed to create my first lookup table, but how should I populate it now?

I tried to insert a record with the SQLite console, but it didn't work.

One more thing puzzles me: I was expecting the newly created SQLite tags to show up in the details section of the properties dialog, but they don't.