I cannot insert rows in Sqlite

MIT App Inventor Help
1

Hello everyone.
I'm trying to insert data in a table in Sqlite and can't do it.
My sql instructions are:

insert into movimientos(key,text1,text2,real1,real2,text3) values(null,
?,?,?,?,?);

**

blocks(1)
blocks(1)1466×250 39.2 KB

blocks
blocks1988×978 120 KB

**

The first field is the key,numeric and is AutoIncrement.
The remaining fields are 3 texts and 2 real.
In the blocks, the text fields are written with " ".

But it is not working!!!
I have a label where i receive the message:

"SQL command completed"
But it didn't add any row.
Any idea is welcome.
Thanks.

Sincerely,
Rafael

2

No closing bracket, ) at the end of your sql statement in the blocks, and you could try the single quotes for all textboxes. You could also show your CREATE TABLE command, so we can see how your "key" is handled.

From the guide:

image
image1161×403 40.2 KB

You also probably do not want to import the read only db from assets each time you start the app, because this will overwrite the default database, and any work you have done on it. Again look at the guide which provides methods for how to handle databases.

3

Use Do it and show us the complete insert statement

Screenshot_20251101_143942_DuckDuckGo
Screenshot_20251101_143942_DuckDuckGo1079×663 65.5 KB

Use the companion app and Do it to debug your blocks, see also tip 4 here App Inventor: How to Learn | Pura Vida Apps
see also Live Development, Testing, and Debugging Tools

Taifun

Trying to push the limits! Snippets, Tutorials and Extensions from Pura Vida Apps by icon24 Taifun.