Problem with SQLite INSERT statement, autoincrement column

[franz1 (Franz Balleis)]

Prolem solved

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.

(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

regards Franz

Are the Infomation exactly enough ?

[Taifun]

as the header id autoincrements, remove that column and its value from the INSERT statement
Taifun

[franz1 (Franz Balleis)]

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

[Taifun]

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…
https://puravidaapps.com/sqlite.php

Taifun

[franz1 (Franz Balleis)]

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);

regards Franz

[Taifun]

@franz1

That would be really great if you could have a look there

here is the result using my sqlite extension
https://puravidaapps.com/sqlite.php

Taifun

[franz1 (Franz Balleis)]

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
once more.

1) the content off the assets

2) the DDL of Inventory

3) see the folderstructur of the testmobil

4. 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 ???

regards Franz

[Taifun]

@franz1

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 )

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

Taifun

[franz1 (Franz Balleis)]

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 ???

greetings Franz

[franz1 (Franz Balleis)]

Nobody an Idea ?

[Taifun]

@franz1

No matter what kind of extension I use, it doesn’t work.

I only can provide support for my own sqlite extension
you might want to try my suggestion from my last contribution

@Taifun

see Q11 about how to do it correctly here App Inventor Extensions: SQlite | Pura Vida Apps

and if you do not get it running, what about providing an updated screenshot of your relevant blocks?

Taifun

[Suraj_Salavi]

I am facing same problem does anyone found solution?

[Rogerio_Rios (Professional Support)]

How to insert a list in SQlite database

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]