Android Question Databases in Service Module

[Reviewnow]

Best way to handle this

When application starts

if firsttime then
dbSQL.Initialize(File.DirDefaultExternal, "my.db", True) < this is correct
end if

when the user closes the application
userclosed = false
the database is no longer available to access in the service module because dbSql is no longer initialized

steps taken to resolve
in service_create

If Main.dbSQL.IsInitialized = True Then
'Do Nothing
Else

dbSQL1.Initialize(File.DirDefaultExternal, "my.db", True)
End If

Please let me know if this is the correct method or the best way to handle this
Thanks

 

[Erel]

This is correct. Another option is to move the SQL variable to a code module and create an init sub:

If SQL1.IsInitialize = False Then
 SQL1.Initialize(...)
End Sub

You should then call this init sub from Activity_Create and Service_Create.

You can keep the SQL object open until the process is killed.