Hello.
How do I achieve in the result of the SQL separator query ";" ?
Ondrej
The "join items using separator" blocks does not make a list, it makes a string of list items separated by the, er, separator, you provide.
Use Do It on your blocks when using Companion to find out what is happening to your query output.
use Do it to debug your blocks, see also tip 4 here App Inventor: How to Learn | Pura Vida Apps
see also Live Development, Testing, and Debugging Tools
Taifun
Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by Taifun.
Hello.
I want to make it in the gListSQL sheet as a separator ";", since the line item with index 6 can be text with spaces ... If the separator is a space, then I can't fill the sheet. I've tried it this way, but it doesn't work for me. I would need to adjust the SELECT result to be with the separator; .
In line mode, I found the following command for SQLite:
$sqlite3 -separator '=%=' my_db.sqlite "SELECT text FROM message;" > out.txt
But how to implement it in a block?
.separator
is a dot command in sqlite cli program.
You cannot use this with the SQLite extensions.
Show your base query output then show how you want it to look.
Hello.
The input is in SQLite, the lines are eg:
((2017) (III) (169) (22) (10.03.2021) (Anna Mária) (Ružičková))
((2005) (VI) (130) (20) (19.08.2019) (Ján Ondrej) (Dostál))
The output is in the list, the lines are eg:
((Anna Mária) (Ružičková) (16.06.2021))
((Ján Ondrej) (Dostál) (19.08.2019))
Ondrej
((Anna Mária) (Ružičková) (10.03.2021))
To be clear, when you run the Execute block with your SELECT query you get this ?
Hello.
Not.
From the TaifunSqlite1 block ... I get:
((2017) (III) (169) (22) (16.06.2021) (Anna Mária) (Ružičková))
((2005) (VI) (130) (20) (19.08.2019) (Ján Ondrej) (Dostál))
Next I read the gListSQL list and I only want items with index 6, 7 and 5 in the listView list
((Anna Mária) (Ružičková) (16.06.2021))
((Ján Ondrej) (Dostál) (19.08.2019))
Ondrej