Android Question SQLite does not write a table

Myr0n

Active Member

Licensed User

Longtime User

• Oct 9, 2018

• #2

Can you post more information please, and will try to help you.

What is your android version?
Did you get any error?
Are you running the app in a physical o emulator device?
What version of b4a are you using?

 

Upvote 0

D

DursunBolat

Member

• Oct 9, 2018

• #3

Android version 4.2.2
No Error
Yes.
8.5.0.0

I do not see operations in the database

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Oct 9, 2018

• #4

You must comment this line in the Starter Module:
File.Delete(File.DirInternal, "persons.db") ' only for testing, removes the database

 

Upvote 0

D

DursunBolat

Member

• Oct 9, 2018

• #5

I got the error.

 

Attachments

• hata.png

  20.8 KB · Views: 123

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Oct 9, 2018

• #6

Try to uncomment the line:
File.Delete(File.DirInternal, "persons.db") ' only for testing, removes the database
This deletes the current database from your device and the program saves the default database on the device and then run the program, does it work?
If yes, uncomment the line above and run the program.

 

Upvote 0

D

DursunBolat

Member

• Oct 10, 2018

• #7

The problem continues.
I'm doing things in application. Does not appear in the database.

 

Upvote 0

Erel

B4X founder

Staff member

Licensed User

Longtime User

• Oct 10, 2018

• #8

You should post your updated project.

 

Upvote 0

D

DursunBolat

Member

• Oct 10, 2018

• #9

Updated Project.
My problem is,
I'm doing transactions in the application.
Operations do not appear in the database.

 

Attachments

• SQLiteLight.zip

  19.3 KB · Views: 115

Last edited: Oct 10, 2018

Upvote 0

D

DursunBolat

Member

• Oct 10, 2018

• #10

No problem. I understand. The application keeps it in the database. I was doing control from the database on the pc.

 

Upvote 0

klaus

Expert

Licensed User

Longtime User

• Oct 10, 2018

• #11

I tested the program, I edited and entry and I added a new entry, this works as expected.
Returning to the Main activity shows the changes and leaving the program and restarting it shows also the changes.
So, how and where do you check the database to say that there are no changes?

 

Upvote 0