jform HowTo Routines

HowTo routines are examples of the dynamic scripting language in jform and show examples of changes on simple Oracle® Forms modules. The routines are written for Forms 6i. If they are loaded in another jform version, the whole routines must be recompiled after import.

For some of the examples, access to the scott/tiger tables is required. For others a particular table structure is required, which can be generated with the attached *.sql script.

• HowTo4: to alter the properties of a block located in a window.
  
• HowTo5: How to add an LOV and a record group.
  
• HowTo6: How to add an LOV trigger for every text item whose data type is ‘date’.
  
• HowTo7: How to reference a trigger from another form.
  
• HowTo8: How to reference a trigger from an object library.
  
• HowTo10: How to sort trigger alphabetically – static version.
  
• HowTo11: How to create a database query with the value of a property and execute the query.
  
• HowTo12: How to write prompts in a database table.
  
• HowTo13: How to carry out substitutions in PL/SQL.
  
• HowTo15: How to find items on a canvas which have been overlapped by other items.
  
• HowTo16: How to sort trigger alphabetically – dynamic version.
  
• HowTo17: How to change reference information from ‘database’ to ‘file system’.
  
• HowTo18: How to reference a trigger when there is a non-referenced trigger with the same PL/SQL code.
  
• HowTo19: How to restore the altered PL/SQL code of a referenced trigger when the PL/SQL code is the same as the code of the referenced trigger.
  
• HowTo29: How to enlarge a form to 12x24 by changing all properties.
  
• HowTo49: How to enlarge a form to 12x24 by changing only non-referenced properties.
  
• HowTo69: How to enlarge a form to 12x24 by changing property classes.
  
• HowTo105: How to alter the format lines (raster) of a canvas.
  
• HowTo106: How to convert boilerplate texts to prompts (single record block).
  
• HowTo107: How to convert boilerplate texts to prompts (multi record block).
  
• HowTo114: How to convert boilerplate texts to display items.
  
• HowTo118: How to convert frame titles to display items.