no internet connection

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
wkotze@wccsoft.co.za
Posts: 10
Joined: Wed 20 Apr 2016 21:12

no internet connection

Post by wkotze@wccsoft.co.za » Wed 20 Apr 2016 21:40

Hi All
Our delphi dx10 fmx software product connect from mobile (android) devices to cloud based sql server via sdac.
It is mainly used for collecting data and cached on device unril it can be applies when connected .
It however sometimes happens that the device is used offline (no internet or reception or avaialibility of sql server at all), How can i start/initiate an offline session? (the sql server is not available at the time the android device is switched on)
thanks
wihan

azyk
Devart Team
Posts: 1057
Joined: Fri 11 Apr 2014 11:47
Location: Alpha Centauri A

Re: no internet connection

Post by azyk » Thu 28 Apr 2016 13:21

Try to use our recommendations from the Working in an Unstable Network article: https://www.devart.com/sdac/docs/?unstable_network.htm . If any questions remain or come up after article reading, please contact us - we will respond.

wkotze@wccsoft.co.za
Posts: 10
Joined: Wed 20 Apr 2016 21:12

Re: no internet connection

Post by wkotze@wccsoft.co.za » Sun 22 May 2016 22:13

Thank you, I did read the unstable section and I do apply as such and its working 100%,
but I want to do is work connectionless until i can connect
e.g.
go with tablet to an offsite location that is totally disconnected from sql server (no internet, no wifi),
then work there connectionless with cached updated,
then when back in the office, apply the updates

ViktorV
Devart Team
Posts: 2299
Joined: Wed 30 Jul 2014 07:16

Re: no internet connection

Post by ViktorV » Fri 27 May 2016 11:55

SDAC has no support for opening tables without connection to the server. You can try to implement the functionality you need by yourself. You can use the TVirtualTable to work with data in off-line mode and TCRBatchMove components to transfer data between TVirtualTable and SDAC datasets. Both these components are distributed with SDAC. See more details about the components in SDAC help: https://www.devart.com/sdac/docs/?devar ... ltable.htm and https://www.devart.com/sdac/docs/?devar ... tchmove.htm
To get additional advices, please clarify: do you mean a situation when you have no connection to the server on application start and you want to work with data?

wkotze@wccsoft.co.za
Posts: 10
Joined: Wed 20 Apr 2016 21:12

Re: no internet connection

Post by wkotze@wccsoft.co.za » Mon 30 May 2016 08:21

Thank you Viktor, I will try you suggestion.

ViktorV
Devart Team
Posts: 2299
Joined: Wed 30 Jul 2014 07:16

Re: no internet connection

Post by ViktorV » Mon 30 May 2016 08:58

Feel free to contact us if you have any further questions about SDAC.

Post Reply