[WM24] How do you add a database into the apk?

Currently I am attempting to push all of my data tables (along with their data) from my server into the generated APK so that my app can be used whilst offline, but there doesn't seem to be any tutorial on what files to include if I want to do this as well as what settings should I apply to each files



Edited 1 time(s). Last edit at 11/21/2019 08:23AM by RobertLeo.

Hi. In the generation process you can indicate which files should be included in the APK. During the start of the application you must detect if the files are already in place and if they are not must extract them to the folder where they should be accessed using the function fExtractResource [doc.windev.com]

Ruben

Roberto

What is your server base?

In your apk application, include the analysis and tables that you want to share, whether you are connecting to the server or using locally.

I personally have an apk that when run picks up data stored in the cloud on my server, the base is MySQL

In apk I use hf clasic base

[infosonline.net]



Edited 2 time(s). Last edit at 11/22/2019 01:40PM by infos.

I use HFSQL C/S

The issue is that since my current database is stored in the cloud, there is no "physical" database to be included within the add file option, and whence I downloaded the tables to my PC and tried to use them, instead of appearing as 1 file per table, each table contains 3 files so I am unsure on which files to include, and what options that I need to pick to make them work on the device

infos Wrote:
-------------------------------------------------------
> Roberto
>
> What is your server base?
>
> In your apk application, include the analysis and
> tables that you want to share, whether you are
> connecting to the server or using locally.
>
> I personally have an apk that when run picks up
> data stored in the cloud on my server, the base is
> MySQL
>
> In apk I use hf clasic base

Robert

In the WM analysis, connect to your cloud base and import the tables into your analysis, you can also include the data together with the tables.

In the analysis, choose what you want with your data


You need to make a connection to the base of your server on your mobile phone and edit how you will buy data from the server

[help.windev.com]


Greeting

[infosonline.net]



Edited 4 time(s). Last edit at 11/26/2019 12:41AM by infos.

Infos, thank you for your input however I am not sure if this is what I needed because I need to use the app without the need of a server just for it's demo build

infos Wrote:
-------------------------------------------------------
> Robert
>
> In the WM analysis, connect to your cloud base and
> import the tables into your analysis, you can also
> include the data together with the tables.
>
> In the analysis, choose what you want with your
> data
>
>
> You need to make a connection to the base of your
> server on your mobile phone and edit how you will
> buy data from the server
>
> [help.windev.com]
>
>
> Greeting

appreciate getting this above info!

Robert

I have to admit I don't understand what you want?

[infosonline.net]

What I need is for the database to be stored inside of the phone via deploying it along with the apk so the phone it is installed to can be used offline without the need to connect to anything, and we will use this for demonstrations at our clienteles

infos Wrote:
-------------------------------------------------------
> Robert
>
> I have to admit I don't understand what you want?

Roberto

The 3 database files you downloaded from the server are data, memo and index files; just add them all during generation and install.

Peter

is there any other settings I need to do beyond that?

Peter Muckle Wrote:
-------------------------------------------------------
> Roberto
>
> The 3 database files you downloaded from the
> server are data, memo and index files; just add
> them all during generation and install.
>
> Peter

No other settings

It's simple, do as Peter said.

I understand you need it database on your phone with data from the server.

You can do that too, I have an app that works that way

WM app: [play.google.com]


Purchases data from RSS feeds [infosonline.net]

The data is entered through the WB application to the cloud server

The WM application uses a local database on a mobile phone. When the application starts, check for new messages, if any, then download them if you are connected to the internet, if you are not connected to the internet then you only have existing data

Check out this WB application that does the same thing as interacting with WM: [infosonline.net]

[infosonline.net]



Edited 5 time(s). Last edit at 11/30/2019 02:47PM by infos.