Axpert 11
TStructs (Forms)
- Create Form
- Create DC
- Create Fields
- Grid DC/frames
- Formulae in fields
- SQL in fields
- Drop down fields
- Autogenerate fields
- Table fields
- File upload fields in forms
- Photos & Image fields
- Fill Grid
- Posting data – Gen maps
- Updating fields in DB tables – MD Map
- Toolbars in tstructs
- Tracking changes/Audit trial
- Try it yourself
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.