Android Question Getting error

[Itila Tumer]

I'm doing database operations on page x.
after
I come to the y page.
I get this error.


java.lang.IllegalStateException: attempt to re-open an already-closed object: SQLiteDatabase: /data/user/0/b4a.example/files/SportExpertDB.db

 

[DonManfred]

The error says it all... You are opening a Database which is already opened.
Without knowing what you are doing and how it is hard to give any concrete advice.

Upload a small project which shoes the issue.

 

[Itila Tumer]

You're right. I didn't install it because the project was large.


https://yadi.sk/d/j8RIfi0FBEIFhQ

 

[Erel]

I haven't checked your project.

Make sure to initialize the SQL object in Service_Create of the starter service. Never initialize it again.

 

[Itila Tumer]

I don't understand where the problem is.
My code blog

Sub Service_Create

CurrentIndex = -1
RowNumber = 0
EditMode = "Add"
FilterQuery = ""
flagFilterActive = False
FilterBooleanOperator = "AND "


If File.Exists(File.DirInternal, "SportExpertDB.db") = False Then

File.Copy(File.DirAssets, "SportExpertDB.db", File.DirInternal, "SportExpertDB.db")

SQL1.Initialize(File.DirInternal, "SportExpertDB.db", True)

Else

SQL1.Initialize(File.DirInternal, "SportExpertDB.db", True)
End If

End Sub

 

[Erel]

1. Please use [code]code here...[/code] tags when posting code.

2. Where is the full error message?

3. Is this Service_Create of the starter service?