Working with SQL

Working with SQL

Reference Sites


Consequences of Unsupported SQL

The All On Mobile system (Bridge and App) has been architected to incorporate the use of SQL to enhance the operation of Forms and Templates. The use of non-supported SQL is discouraged due to the likely negative end-user performance impact when run on mobile operating systems which are not optimised for SQL usage.

Time and Date

In v4.2.1 Time and Date fields have been introduced as well as the ability to perform a 'Diff' between two time and date fields. All SQL associated with time and date calculations will not be supported post v4.2.1 release.