Steps to be followed when using application builder

Lists in detail the options to be used when using application build to build all pages consistently. All application pages should reside within some folder and not on the root directory. Only Header/Footer/Login/etc may reside on the root directory.

Below is how to use the wizard and options to be chosen

1. Choose “Create a New Page”
2. Choose the existing connection
3. Builder Options
   1. Check Enable smart naming
   2. Choose auto increment PK depending on if you are using sequences for that table or NOT
   3. Uncheck “Use single keyword field …”
   4. Uncheck “Publish site after …”
   5. Check “Use popup date picker”
   6. Check “Internationalized”
   7. Check “Save Builder Options”
   8. Choose “Display buttons as Buttons and NOT Images”
4. Select the tables - the point to note here is that if you are using multiple tables they all use the above options (especially the PK one)
5. On the generate page components page
   1. For each table choose the options to generate and security to choose from
   2. Click on each table (if multiple and do the following)
      1. Search Option
         • Think through the fields to search on, and exclude Audit fields (such as create/update user/date)
         • On the control type for all fields, check each one and mark them all as “TextBox”. Some of them will be “Listbox” depending on if you have FKs on in the table. Do no leave them as Listbox or it will create a join SQL and mess/complicate the underlying SQL.
         • Leave Orientation as Vertical
         • Click the advanced button and choose
           • POST method with validation
           • Multiple columns using AND condition
           • Check “Add a clear option/link”
           • Check “Make search button active by default”
      2. Grid Option (click on the tab)
         • Choose page name - make sure it is all lower case and “nice”. E.g. menu_list instead of SE_MENU_list
         • Choose correct order by
      3. Link Option (usually no changes here)
      4. Record Option
         • Choose PK if not already chosen correctly
         • Again make sure the Control type is “TextBox” for all controls
         • Choose a more likable page name
      5. Preview (ignore this one)
   3. Click next and choose the style
   4. Click next and pretty much ignore the summary listed!
   5. Click Finish

There will typically be a list and maint screen for each table - unless some funky options were chosen. Here are the set of things to do to get the page going

1. Open locales and update all of the descriptions to be more readable
2. Change all of the reference table related fields (especially the _SW columns) to become listboxes and choose from the reference table. Below is the procedure. This needs to be done for both the maint and list pages.
   1. Right-click on field and change to Listbox
   2. In the properties choose
      1. Connection (e.g. dbconn1)
      2. Data Source (e.g.RT_VALUES), Using query builder do the following
         • Choose code and description values to display and they could be the same (e.g. RT_VALUE)
         • Choose where clause - e.g. RT_ID = 'YESNO'
         • Choose order by clause - e.g. SORT_ORDER
      3. An alternative to this is to choose SQL and just use this SQL: SELECT RT_VALUE FROM RT_VALUES WHERE RT_ID='YESNO' ORDER BY SORT_ORDER
      4. Choose bound column (e.g. RT_VALUE)
      5. Choose text column (e.g. RT_VALUE)
      6. If using lower case column names: SELECT rt_value FROM rt_values WHERE rt_id = 'YESNO' ORDER BY sort_order
3. In the maint add a cancel button that does not seem to get generated by default
   1. Click to the left of the list of buttons to insert the “Insert Button”
   2. Add space and click Button on forms
   3. Click on the button and replace the text under “Format –> Values” from Button1 with {res:CCS_Cancel}
   4. Go to properties
      1. Under Data Tab
         1. Under Name property, Rename Button1 to Button_Cancel
         2. Choose “Cancel” in operation
         3. Change “Enable Validation” to No
4. In the maint page
   1. Change formatting of audit fields
      • To be on one line with four columns
      • Create a header row with title as {res:OT_CR_UP_LABELS}
      • Format the above label with black text and box
   2. Delete the date picker for the dates
   3. Change audit fields as indicated here
5. In the list page
   1. Center all _SW fields (rather than being left justified for text)