Android Question Theading question Service Module

[rkxo]

Hi,
Is it possible to call a function in main class that will update the controls from a thread in a service module?

example.
Main class

Sub Activity_Create(FirstTime As Boolean)
StartService(SQLSERVICE)
end sub

sub update()
text="abcdefghi...."
end sub

service module SQLSERVICE
thread.start("sql",null)

sub sql()
connect database......etc
...
...
thread.RunOnGuiThread(Main,"Update",Null) 'error
end sub

if i call with CallSub(Main,"update")
appears android.view.ViewRootImpl$CalledFromWrongThreadException: Only the original thread that created a view hierarchy can touch its views.
Thanks

 

[rkxo]

i found it..
main.thread.RunOnGuiThread("Update",Null)

 

[Erel]

You don't need to use the threading library when working with databases. Use the async methods instead.

[B4X] SQL with Wait For

 

[rkxo]

its possible async method with with MysqlHandler and ResultSet for mysql?
thanks

 

[Erel]

Switch to JdbcSQL which supports MySQL and supports async methods.

 

[rkxo]

thanks erel