Agile Developer

SQL in fields

Axpert 11
TStructs (Forms)
Axpert Jobs
Axpert Cards
HTML Plug-ins
Users & Roles
Axpert API
Application Var/Params
Publish Axpert Apps
Axpert Mobile

SQL in fields

A query can be assigned to a field. At run time, the SQL will be executed. The value in the first row and the first column will be assigned as the field value. SQL may have parameters. The parameters may be field names from this tstruct/form. Fields that are before this field can be used as SQL parameters. If the suggestive property is set to true, the value that is filled can be changed by the user.

For example, Calculate the employee’s age using the date of birth. Create a field named age and write an SQL query to calculate as shown below

Try Out

In the Employee Master, set a condition for restricting the employee age. Accept the entry as an employee, only if the age is greater than 18.