Android Question How do I open a database once and use it throughout the application

[davepamn]

'sqlite module
    sub process_globals
      Dim oDB As cBTDatabase
    end sub

'cBTDatabase class
sub process_globals
  dim localSQL as sql
end sub

    If sqllite.oDB.IsInitialized=False Then
        sqllite.oDB.Initialize
        sqllite.oDB.OpenDatabase(Main.Database)
    EndIf

I don't want to have to keep checking in each activity if the database is available.

Is it possible to keep the cBTDatabase class variables persistent

 

[barx]

I declare it in a code module and use it from there.

 

[davepamn]

that seems to work. I am unit testing it now.

 

[Erel]

Note that it will be simpler in the next version of B4A with the new Starter Service feature.