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.