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