B4J Question sql from inernet database to deek-top

[Robioptic]

Hi

Am looking forward to playing with the system- it looks very very neat ... cause am a Vb fan from way back hahah

Just one question... I saw some stuff but not sure if or how it will work...

1- database is on web

2- i get some data through sql ( currently to display active webpages - then download as text and then import into desk-top appp- which is lame hahah

3- Question: can i directly import data into my eg. windows desk-top app from internet based database ?

 

[Erel]

can i directly import data into my eg. windows desk-top app from internet based database ?

Yes. The jSQL library allows you to connect to remote databases. Make sure to use the asynchronous methods (which are simpler with the new Wait For keyword: [B4X] SQL with Wait For )

While starting with jSQL is a good option, in the long run it is better to use ConnectionPool (from jServer library) to manage the remote connections.

SQL tutorial: https://www.b4x.com/android/forum/pages/results/?query=b4j+sql

 

[Robioptic]

tanks for the tips