Agile Developer

SQL in fields

Axpert 11

TStructs (Forms)

IViews

Scripts

Axpert Jobs

Axpert Cards

HTML Plug-ins

Users & Roles

Workflow

Axpert API

Application Var/Params

Publish Axpert Apps

Axpert Mobile

Settings

Utilities

Customization

WebServices

Axfast

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.