Hi everyone!
I have a Mysql query that returns (id, nome, materia, turmas, email, senha) which I store in a List.
Now, I want to insert the data of this list in the SQlite database that I’ve created.
Any help?
I come from PHP language. It’s my first project in Kodular.
I’m pretty sure the blocks aren’t ordered in the correct way
Welcome.
Friend, the return of your Select shows different fields in each column.
take item 2 from each item…
Julio
Inglês
11,12,13
bigshoio85@
1…
I’ve edited the return of the query.
Now it doesn’t return 12 values as it used to return earlier, but only 6 (id, nome, materia, turmas, email, senha)
Now , You Will use Select item List
one select inside the other
And for each
The question is… How?
What method are you using to connect to sqlite?
Your return is :
( (id, nome, materia, turmas, email, senha) (id, nome, materia, turmas, email, senha)) ?
Use 2 Blocks Select item List ( like Image above )
Field 2 and 3 from list.
I’ve created the table in the first line of my code with this query: CREATE TABLE IF NOT EXISTS professor
( id
INTEGER, nome
TEXT, materia
TEXT, turmas
TEXT, email
TEXT, senha
TEXT);
I’m trying to insert using "Call Sqlite1.Insert.
Thanks, but for this project I need to work with SQlite database.
Thanks, buddy!
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.