How to use Sql Query (SQLite) answer

[christophe_D]

Hello,
I use this block, I don’t know if it’s really the right solution.
but I have a result in the form (value 24) how to exploit the result.
I manage to deal with SQL queries, and it seems to me SQLite uses the same syntax, but how to use it with blocks correctly
Thank

[Still-learning (1-2-3-4...)]

If the result is not in list manner then use split the text at space … now you will have the list and use select list item block with proper index to take the required value . If brackets appears even after splitting the text then use replace text block

[christophe_D]

@Still-learning

If the result is not in list manner then use split the text at space …

I look this SQLite doc the result is “YailList” , how to decode ?

And i don’t, it’s a bug : i do “UPDATE test SET valeur=‘test moi’ WHERE nom=‘pseudo’;”
the answer is “(nom, valeur dist,24 cp,25500 pseudo,test)” for “SELECT * FROM test” the value pseudo seen to be truncate.
thank

[christophe_D]

Hello
I did this, I don’t know if it’s really clean but it works

[Taifun]

the result is a list… learn to work with lists…

• How to work with Lists by Saj
• How to work with Lists and Lists of lists (pdf) by appinventor.org

Taifun

[Taifun]

@christophe_D

And i don’t, it’s a bug : i do “UPDATE test SET valeur=‘test moi’ WHERE nom=‘pseudo’;”
the answer is “(nom, valeur dist,24 cp,25500 pseudo,test)” for “SELECT * FROM test” the value pseudo seen to be truncate.

what is your create table statement?
Taifun

[christophe_D]

@Taifun

the result is a list… learn to work with lists…

• How to work with Lists by Saj
• How to work with Lists and Lists of lists (pdf) by appinventor.org

Taifun

thank you very much, i will read carefully

@Taifun

what is your create table statement?
Taifun

In the end, it’s an error in my UPDATE test SET value=‘test me’ WHERE non=‘pseudo’;

[Rogerio_Rios (Professional Support)]

1-You’re confused… show what @Taifun asked for.

2-