Devart Forums

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

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.

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

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?

Thank you Viktor, I will try you suggestion.

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