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 !
Hi there
I am new to the Kodular topic and I have a problem with SQLite.
Hi Taifun,
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
regards Franz
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_item] TEXT,
[line_location] TEXT,
[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);
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.
Hi,
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 ???