Android Question Best way (proper way) to define a sqlite conecction?

[cheveguerra]

Hi everybody,

I would like to know what us the best way to manage connections to a sqlite db, the way I see it, there are 3 options:

First one:
Declare, initialize and use the connection in every Sub of an activity:

Sub whatever
  Dim skmt As SQL
  skmt.Initialize(pathToDB,"kmt.db", True)
  c=skmt.ExecQuery("SELECT * FROM table1")
End Sub

Second One:
Declare in Activity.Globals, initialize in Activity.Create and use in any Sub we need it:

Sub Process_Globals
    Dim skmt As SQL
End Sub
Sub Activity_Create(FirstTime As Boolean)
    skmt.Initialize(pathToDB,"kmt.db", True)
End Sub
Sub whatever
    c=skmt.ExecQuery("SELECT * FROM table1")
End Sub

Third One:
Declare as global in starter, initialize in starter and use in whatever activity we need it:

STARTER
Sub Process_Globals
    Dim skmt As SQL
End sub
Sub Service_Create
    skmt.Initialize(pathToDB,"kmt.db", True)
End Sub

ANY OTHER ACTIVITY
Sub whatever
    c=Starter.skmt.ExecQuery("SELECT * FROM table1")
End sub

So, please advice on pros and cons and No No's

Best regards

 

[Erel]

All these options are bad.
You should switch to B4XPages and initialize it in B4XPage_Created of the main page.

 

[Mahares]

initialize it in B4XPage_Created of the main page.

What about in Public Sub Initialize of B4XMainPage. That is where I usually initialize it. Is it still ok.

 

[Erel]

Also good.

 

[cheveguerra]

All these options are bad.
You should switch to B4XPages and initialize it in B4XPage_Created of the main page.

I can do that for new projects, but for old ones?

 

[cheveguerra]

I can do that for new projects, but for old ones?

Also, my project needs to change orientation in 2 activities ... is BX4Pages still limited to one orientation??

 

[Erel]

is BX4Pages still limited to one orientation??

Yes, but you can have additional activities that are not locked.

but for old ones?

The third option is the best one for non-B4XPages projects.

 

[cheveguerra]

Yes, but you can have additional activities that are not locked.


The third option is the best one for non-B4XPages projects.

Perfect!! thanks a lot!