Working with SQL

Reference Sites


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.


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.