Android Question Service and SQLite.

[dragonguy]

My application have a one Service and 4 Activity Modules, all need to connect to one SQLite database.
is it only dim sql at Service Module and another 4 Activity Modules can use it?

i mean like this:

Service1 code:

Sub Process_Globals
   Dim serv_SQL As SQL
End Sub

Sub Service_Create
   If File.Exists(File.DirDefaultExternal, "PhoneData.db3") = True Then
     serv_SQL.Initialize(File.DirDefaultExternal, "PhoneData.db3", True)
   End If
End Sub

and then another modules just use code like this:

Query = "UPDATE TblJob Set TimeIn = ?, WHERE CaseNo = ?"
         Service1.serv_SQL.ExecNonQuery2(Query, Array As String("10:00","1234"))

is it correct way to use it?

 

[keirS]

You have the right sort of idea but to call a sub from a service you should use CallSubDelayed(). See this tutorial.

 

[dragonguy]

Thanks for reply, i like to ask about when i do insert or update sqlite database, is it need to use BeginTransaction and EndTransaction?

 

[edgar_ortiz]

define a transaction in the most recommended.

At the end you lose nothing.

Regards,

Edgar