🟥 [FREE] SimpleSqlite - an extension for working with SQLite Databases

[Kleyber_Derick]

Hi @TIMAI2,

I'm facing problems when I'm trying to use the tables. Let me explain what my app does:

1 - When the app is started for the very first time, it has to create all tables needed in SQLite.

2 - After that, it goes to another screen and when press a button, it will fill them with remote data (from a MariaDB remote database).

3 - At the end, it goes to the menu screen.

PS: I'm putting the Open Database in the Initialize and the Close Database in the BackPressed methods.

When I try the App, it gives me the error no such table: materiais (is one of the tables), indicating that the table does not exists.. And the message appears for all tables which were already created in the Screen1.

Waiting for any help or ideas.

[TIMAI2]

You do not appear to be doing any checking, after each stage. Are the tables created?Have the data inserts to tables worked?

[Kleyber_Derick]

@TIMAI2

Are the tables created?

How to check this, when there is no return from the CREATE DATABASE command?

@TIMAI2

Have the data inserts to tables worked?

No. It shows the error I told you before.

[TIMAI2]

@Kleyber_Derick

@TIMAI2

Are the tables created?

How to check this,

Read my guide:

METRIC RAT AI2 - Working with SQLite

in the DATABASE SQL section

@Kleyber_Derick

@TIMAI2

Have the data inserts to tables worked?

No.

Did you see this ?

SQLite extension again: how do you read the JSON received with a different SQLite extension

See here (scroll down a bit) You could try something like this: [image]

[Kleyber_Derick]

Ok thank you

[TIMAI2]

Here is a simple demo

simplesqlitedemo.aia (24.8 KB)

Some of the commands are useful while you are developing only...

Here also is an empty sqlite database file. You can import this to the default database in order to "reset" to an empty database

empty.db.txt (8 KB)

(remove the .txt so that you just have empty.db)