2.3 Data Sources

This topic describes about defining the data sources for Online Forms.

On the Function Generation screen menu, click DataSource.

Identify the tables/views for the Online form. Define data sources and add data source fields as required.

Figure 2-4 Adding data sources and maintaining properties

Description of "Figure 2-4 Adding data sources and maintaining properties"

Note the following while creating data sources:

• Master Data Source has to be a single entry data source.
• Logical Relationships has to be maintained for all data sources except the parent.
• Provide PK Cols and PK Types for all data sources. If the data source is a multi-record block, then make sure it has at least one more pk than its parent which helps to identify each record of multi-record block uniquely.
• Minimize the use of views in the data sources. For transaction screens, system generated upload logic (fn_sys_upload_db) is not called within the system package. It is up to the developer to decide whether the system generated code can be used or not. If views are used in data sources, then this function should not be used by the developer.
• Usually for Online forms, a separate view can be used for summary purpose. This view will have all the fields required to be displayed in the summary. Example: UTDTXN01_SUMMARY.

  Figure 2-5 Adding data sources fields and its properties

  
  

  
  Description of "Figure 2-5 Adding data sources fields and its properties"

  
  

Note:

Max length of the data source field can be modified as per requirement.