Android Question DBUTILS - Executehtml(), non-fatal error?

[JohnD]

Sometimes I get an error reported, "Object should be initialized" on line [317] of DBUTILS. The code is:

cur = SQL.ExecQuery(Query)

I assume the error is referring to the SQL object. I only get it after I have been interacting with my program for several minutes. I assumed that there is no way to "un-initialize" the SQL object? I do make several (successful) calls to Executehtml(). I can't reproduce this bug at will.

 

[Erel]

Where is SQL initialized?

 

[JohnD]

Main.Activity_Create()

If FirstTime Then

'''File.Delete(File.DirDefaultExternal, DBFileName) ' for testing

If File.Exists(File.DirDefaultExternal, DBFileName) = False Then
DBFileDir = DBUtils.CopyDBFromAssets(DBFileName)
End If
SQL1.Initialize(DBFileDir, DBFileName, True)

End If

declared in:

Main.Sub Process Globals()

Dim SQL1 As SQL

end sub

I think the error might have something to do with the "empty table condition" for a query. I'm going to put some work into reproducing it.. Unless something jumps out at you from above. Thanks, JD.

 

[Erel]

Please use [ code ] [ /code ] tags (without spaces) when posting code.

Is it possible that the process was started from a service and not from the main activity?

 

[JohnD]

I did a global search on: SQL1, SQL, and .Initialize. The only place any SQL object is being initialized is in the Main activity.

 

[Erel]

Can you upload your project (File - export as zip)?

 

[JohnD]

Erel: I cleaned up my code - deleted several of my unused maps objects and the problem went away. I wish I could tell you exactly what fixed it, but I don't know. Maybe a memory conflict? Thanks, JD.