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

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.