Inputfields are the data elements in the Tstruct. An input field belongs to the DC defined above it. The fields are displayed as components in the form. For Grid DC, the input field is created as a column in DC frame.Internally, the input field is created as a field in the database table associated with its DC.
The Mode of entry, Details & Expression are the major properties that govern the way data is populated or calculated into a field. The data in a field could be auto generated, calculated or selected based on the property values.
Classification of Input Fields
Input fields are classified into
- Accept fields
- Select fields
- Calculated fields
- Autogenerated fields
- Fill fields
InputFields as memory variables
Often, an application needs variables for performing intermediate calculations.In such cases, the values need not be saved. Axpert allows the usage of input fields as variables. For this, set the Save Value property of input field to false. This avoids the saving of the field to the table. Such input fields are just data elements that can be used as memory variables for any calculation.
For instance, while generating a Payslip for employees, there are certain fields such as Basic, DA, Advances etc. that needs to be entered and stored in the database. In such cases the SaveValue property is set as True. In the same payslip, there may be a field called Total Pay Amount (given by Basic +DA + Advances) that just requires to be displayed. As there is no necessity to store the calculated Total Pay Amount, you can set the SaveValue as False. During runtime, the total amount will be calculated and displayed but will not be saved in the database.