Armeria89
(Armeria89)
March 19, 2023, 1:42am
#1
I have a problem importing a SQL database. I’m using an extension, which is org.bennedum.SQLite.aix
These are the blocks that I use to import the database, but it returns false when I try to import.
Thanks!
Rogerio_Rios
(Professional Support)
March 20, 2023, 7:06pm
#2
To work with a SQLite type database you will have to use SQL commands.
Hi,
I would like to create a select using 2 Text box, ie create a select Example:
Select name from varietals where species = ‘bird’ and color = ‘black’
I don’t know how to create using this SQLite box.
[image]
can you help me?
I have a query:
“SELECT … WHERE date_milisecs >= Clock1.getMilis AND date_milisecs <= Clock2.getMilis”
The problem is that the SQLite read only
"SELECT … WHERE date_milisecs >= Clock1.getMilis AND date_milisecs "
I dont now how to escape “<=” in query.
I try / and <, but no success.
[sqliteError]
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
[blocks]
Armeria89
(Armeria89)
March 21, 2023, 1:07am
#3
I know, but my problem is not working with it, it is importing a database
Taifun
March 21, 2023, 2:37am
#4
Armeria89:
importing a database
You need an extension, which offers an Import method… does that extension offer this functionality?
My sqlite extension does…
Taifun
Rogerio_Rios
(Professional Support)
March 21, 2023, 9:03am
#5
Well, I have applications that do this: I import data from a database on the web (from mysql in host to SQLite - record by record ).
and I perform this import with SQL commands.
Hugs