Versions Compared
Key
- This line was added.
- This line was removed.
- Formatting was changed.
Table of Contents |
---|
Description
The following are notes on the use of SQLite functions within All On Mobile. It is not designed to be a tutorial on the use of SQLite. For more information on SQLite functions please see the websites in the reference section of this page.
Calculated Field Overwritten by User
If a field value is derived (as in the example), if the field is not set as as being 'locked' then the Mobile Device user can overwrite the derived value. Field C is derived by adding together Field A and Field B (1 + 3 = 4). | Image Modified | |||||
The Mobile Device User has chosen to overwrite the derived value of 4 with the value 22. | Image Modified | |||||
| Image Modified |
Page Calculation
When deriving information from fields on other pages within All On Mobile it is important to remember the following tips:
|
Downloading Databases
Description | iSO | Android | |
---|---|---|---|
1 | From the 'Hamburger Menu' () select 'Databases'. | ||
2 | The list of Databases that have been successfully downloaded to the Mobile Device are listed. | ||
3 | If no Databases have been downloaded a message stating that "You don't have any databases downloaded on your device" is displayed. You can trigger databases to download by pressing the refresh button on this page. |
Warning | ||
---|---|---|
| ||
Off-line Databases can only be downloaded when the Mobile Device is connected to a WiFi network. Database download is disabled over 3G/4G. |
SQLite Version
The SQLite version running on the Mobile Device can be checked via the Settings Menu on both Apple and Android Mobile Devices.
Tip | ||
---|---|---|
| ||
To check if the version of SQLite that is installed on the Mobile Device is compatible with All On Mobile please check the /wiki/spaces/AOMP/pages/5079054. |
Time and Date Format Change
In order to support SQLite time and date functions the text format of the time and date in All On Mobile has been change in All On Mobile v3.1 to a numeric format.