This section describes the basics one needs to know for creating a TStruct in Axpert. A TStruct is defined within a TStruct definition window.
- To view the TStruct definition window,open the TStruct in the Build mode . i.e. click New-> Form/TStruct
- In the new TStruct definition window that opens, there are two tabs ,Structure and Form. By default, the Structure mode is active. The Structure mode is used to define the data elements and other components. The Form mode contains the elements defined in the Structure mode as drag and drop components .
- The TStruct definition window is in the form of a grid.
- Each row in the grid represents a component in the TStruct.
- On clicking any row, the corresponding component’s properties are shown in the property panel on the right side.
- Each component in the TStruct has a Type, Name and Caption. These are the columns in the grid.Type refers to the type of process structure or the component. The Name values correspond to the fieldnames in the database.Caption is the user defined name given to the structure or component.
- The first row in the grid describes the TStruct.By default, a TStruct is named as TSt<no> . This is also known as the the transid. The transid of the TStruct should be unique.
- Click on the first row to view and set the TStruct properties in the property panel.
Data Container (DC)
- The second line in the TStruct describes the Data Container.
- A DC is a logical container that groups a set of fields and is displayed as a frame in the input form.
- Creating a DC creates a table in the database.The table name can be specified in the Table Name property of the DC.
- The DC Name cannot be changed. By default it will be dc<no> .
- All the fields that follow the DC grid line will be created as fields in the corresponding table and are displayed within the frame.
- There can be any number of DCs in a TStruct and each DC can have a different table name. All these tables are related by storing the record id of the primary table in all the other tables. The table attached with the first DC is called the primary table. More than one DC can point to the same table name. More than one TStruct can point to the same database table.
- Input fields are the data elements in the TStruct. An input field belongs to the DC defined above this field.
- A DC can have any number of input fields.
- The input fields can be of Character, Numeric, Data/Time, Image, Text or custom datatype and they are stored as fields of the corresponding DC table in the database.
- Every datatype chosen for an input field obeys the database rules and restrictions for the datatype depending on the database.
- Input fields could belong to the following Mode of Entry :
MDMap, GenMap and FillGrid are together known as Process Maps. Process maps provide a way of relating TStructs and passing data from one transaction to another.