Adding Additional Processing Logic
Depending on the type of columns that you add, associated processing logic may be needed. For example, you may need to add processing logic to:
• Save edited data into the wo_mstr, wod_det or other database table(s)
• Calculate the values for a calculated column
• Perform validations on edited data
The architecture provides user exits that you use to implement additional processing logic; see
User Exits.
ProDataSets and Temp-Tables
The MSW/PSW uses ProDataSets to send/receive data between the MSW/PSW .NET UI client and the server-side .NET UI. Basically, a ProDataSet is an in-memory data structure that consists of a number of temp-tables. Temp-tables are like database tables except that they are in-memory data structures. There are temp-tables defined for wo_mstr and wod_det.
When you invoke a search, the server-side logic creates a ProDataSet and populates its wo_mstr and wod_det temp-tables with records from the corresponding database tables and sends it to the client-side logic. When you save, the client-side logic creates a ProDataSet and populates its wo_mstr temp-table with modified work order records and sends it to the server-side logic.
Work Order Master Temp-Table Definition
The wo_mstr temp-table definition is contained in the woscwo.i include file. The temp-table is defined like the wo_mstr database table, so it contains all fields that are defined in the wo_mstr database table schema. When you need to add a calculated field to this temp-table definition, you add it to the woscwox.i include file which woscwo.i references.
Work Order Detail Temp-Table Definition
The wod_det temp-table definition is contained in the woscwod.i.include file. The temp-table is defined like the wod_det database table, so it contains all fields that are defined in the wod_det database table schema. When you need to add a calculated field to this temp-table definition, you add it to the woscwodx.i include file which woscwod.i references.