Having some fun with sqlite in maxmsp. Thanks for tutorial!
A lot of requests are working BUT I cannot have a list of the names of the tables themselves.
I have try
exec "show tables"
exec("SELECT * FROM ‘"+database+"‘ WHERE type=’table’ ORDER BY name");
Need a little help.
I generate tables names trough a autopopulate umenu…
You can do that using the sqlite_master table.
SELECT * FROM sqlite_master
It’s explained in the Querying the SQLITE_MASTER table paragraph.
Thanks it works!
Log in to reply
Let us tell you about notable Max projects, obscure facts, and creative media artists of all kinds.