The SQLite database was located in the assets folder! But in this folder its not possible to make changes. So you can read from this SQLite Database without trouble but other operations like insert,update or deletes are not possible !!!
Solution use your own folder !
I am new to the Kodular topic and I have a problem with SQLite.
(1) .OpenDatabase is reporting ok
(2) When i try to insert to the db I get an Error -1
What is wrong ?
tabeldescription… header_id with autoincrement
Are the Infomation exactly enough ?
as the header id autoincrements, remove that column and its value from the INSERT statement
I’ve had SQL know-how for several decades, so my first try was without this field, since I expected this field to be filled in automatically. But I have the problem with or without the ID Field
as test try to create a table without auto increment to verify, if the INSERT statement works there…
EDIT: you might want to provide a CREATE TABLE statement for that table, so I can test it in my sqlite extension…
Good morning Taifun,
That would be really great if you could have a look there. Here are the tables in the database inventory
CREATE TABLE [inv_header](
[header_id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[header_date] TEXT NOT NULL,
[header_user] TEXT NOT NULL,
[header_text] TEXT NOT NULL UNIQUE,
[header_warehouse] TEXT NOT NULL,
[header_type] INTEGER DEFAULT 0,
[header_status] INTEGER NOT NULL DEFAULT 0);
CREATE TABLE [inv_line](
[line_id] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
[line_header] INTEGER NOT NULL,
[line_pos] INTEGER NOT NULL DEFAULT “1”,
[line_type] INTEGER DEFAULT “1”,
[line_qty_stored] INTEGER DEFAULT 0,
[line_qty] INTEGER NOT NULL DEFAULT 1,
[line_time] TEXT NOT NULL DEFAULT (DATETIME ()),
[line_counted] BOOLEAN NOT NULL DEFAULT FALSE);
here is the result using my sqlite extension
Hi Taifun, i get crazy
Now I tried with your extention and with blocks from your testapp. I gget no result ???
What do I wrong
1) the content off the assets
2) the DDL of Inventory
3) see the folderstructur of the testmobil
- and now your code with my changes
5) the result ind lbl_count_Liste is
ERRPOR: no such table: Inventory.invheader (Sqlite code 1 SQLITE_ERROR):; while compiling: SELECT COUNT (*) from inventory.inv_header(OS error - 2 no such file or directory )
Besides I’ve teset with and without the databasename same result.
What dooing i’m wrong ???
this happens, because you do not use the Kodular workaround for the IMPORT method correctly
see Q11 about how to do it correctly here App Inventor Extensions: SQlite | Pura Vida Apps
once more, but i don’t get sqlite up and running. No matter what kind of extension I use, it doesn’t work. In the end, is it due to my test phone or Android version 9.xx?
These little idiot procedures show the hurdle that I still have to overcome so that I can create useful apps.
The same result in both cases. I should mention one more thing. I noticed that when I create a data record with an external editor in the table inv_header, this record suddenly disappears after executing one of the two procedures ???
I only can provide support for my own sqlite extension
you might want to try my suggestion from my last contribution
and if you do not get it running, what about providing an updated screenshot of your relevant blocks?
I am facing same problem does anyone found solution?