• CR# 2105890: German ApexLib Error Messages
• Bug# 2277911: Exception on using apexlib.error.show for TabForm-Item
• CR# 2778787: automated apexlib integration
• Bug# 2163173: Number 0 not a number according to apexlib.convert.toNumber
• Bug# 2016210: Show error message on top and bottom of page
• CR# 1793238: ApexLib should use jQuery 1.3

Whats new:

• Automatic integration Script ApexLib_integrate_into_application.sql
• AJAX Computations
• Keyboard Shortcuts for Buttons
• Boolean Checkbox handling
• using jQuery 1.3.2 (namespaced to apexlibJquery)

Upgrade instructions:

Since the last official release some things have changed in regards of how to integrate ApexLib into your application.

Take a look at the manual integration instructions to see what the integration code now should look like.

If you upgrade from v1.6/v1.7 you need to


• add new Application Item APEXLIB_ROUTINE_TYPE
• remove Application Process ApexLib_getLovResult
• add Application Process ApexLib_getGenericResult
• update code in Application Process ApexLib-Before Computation/Validation
• update Page Zero Regions according the manual integration instructions
• change all references of jQuery (or $ as shortcut for jQuery) in your code to apexlibJquery

Files added/changed:

• ApexLib_load_apexlib_messages_de.sql [ Added ]
• apex_builder_plugin_143_apexlib.js [ Added ]
• apex_builder_plugin_4314_apexlib.js [ Added ]
• apex_builder_plugin_4315_apexlib.js [ Added ]
• ApexLib_Button.js [ Added ]
• ApexLib_Compressed.js [ Diff ]
• ApexLib_Convert.js [ Diff ]
• ApexLib_Core.js [ Diff ]
• ApexLib_Error.js [ Diff ]
• ApexLib_Field.js [ Diff ]
• ApexLib_Full-min.js [ Added ]
• ApexLib_Full.js [ Added ]
• ApexLib_Lov-min.js [ Added ]
• ApexLib_UI.js [ Diff ]
• ApexLib_Validation.js [ Diff ]
• jquery.hotkeys.js [ Added ]
• jquery.hotkeys.min.js [ Added ]
• jquery.js [ Diff ]
• jquery.min.js [ Added ]
• jquery_Compressed.js [ Diff ]
• namespaceJquery.js [ Added ]
• ApexLib_views_for_apex_tables.sql [ Diff ]
• ApexLib_views_for_apex_views_22.sql [ Diff ]
• ApexLib_views_for_apex_views_30.sql [ Diff ]
• ApexLib_Browser.pkb [ Diff ]
• ApexLib_Button.pkb [ Added ]
• ApexLib_Button.pks [ Added ]
• ApexLib_Check.pkb [ Added ]
• ApexLib_Check.pks [ Added ]
• ApexLib_Computation.pkb [ Added ]
• ApexLib_Computation.pks [ Added ]
• ApexLib_Generic.pkb [ Added ]
• ApexLib_Generic.pks [ Added ]
• ApexLib_Item.pkb [ Diff ]
• ApexLib_Item.pks [ Diff ]
• ApexLib_Load_All_Packages.sql [ Added ]
• ApexLib_Lov.pkb [ Diff ]
• ApexLib_Lov.pks [ Diff ]
• ApexLib_Sql.pks [ Diff ]
• ApexLib_Sql_for_apexlib_schema.pkb [ Diff ]
• ApexLib_Sql_for_application_schema.pkb [ Diff ]
• ApexLib_install_into_apexlib_schema.sql [ Diff ]
• ApexLib_install_into_application_schema.sql [ Diff ]
• ApexLib_integrate_into_application.sql [ Added ]

• CR# 1988122: Add trim for page items and tabular form columns
• CR# 1703163: Add support for installing apexlib onto apex.oracle.com
• CR# 1709776: Remove APEX Builder Plugin from ApexLib codebase
• CR# 1815931: PageFlow Diagram: mark branches with a button condition red
• CR# 1815957: PageFlow Diagram: separate shared component entries with a line separator
• CR# 1815945: PageFlow Diagram: add support for tabs and nav bar
• CR# 1868254: Configurable temporary tablespace
• CR# 1869727: Add support for the new item type HIDDEN_PROTECTED
• CR# 1721220: Support error DIV which is identified by ID
• Bug# 1988285: Error highlighting for date picker items not work in 3.1.1
• Bug# 1700080: IE: Popup lov doesn't close anymore with ApexLib 1.6
• Bug# 1703537: CR/LF in template definition causes runtime error
• Bug# 1706023: ApexLib.css: Warning: Selector expected. Ruleset ignored
• Bug# 1710655: Cascading Lovs do not work on public pages
• Bug# 1714441: $APEXLIB_IGNORE_VALIDATION$ doesn't work for page items
• Bug# 1719360: Use APEX built-in package for debugging messages
• Bug# 1772657: Strange CLOB to VARCHAR2 conversion bug in Oracle 9i
• Bug# 1818120: HTML buttons are disabled after a validation error
• Bug# 1894423: Structure of some pages in APEX Builder has changed in 3.1
• Bug# 1923251: Format Mask with HH:MI doesn't work
• Bug# 1936144: Error if error stack of tabular form gets to big
• Bug# 1962627: Cascading lov doesn't work in IE
• Bug# 1884851: Javascript error when "Text Message" contains "\n"
• Bug# 1686127: Error processing TabForm when row selector column is not displayed

Upgrade instructions:

• Follow the steps in the Upgrade chapter of the How To Install document.
• Follow the steps in chapter 2 of the How To Integrate document and copy the newest files to the Application Server, or include the content directly into your Page 0 and Popup Lov template.
• Follow the revised steps in the "Integration into your Application" chapter of the How To Integrate document:
  • Step 7: Create an Application Process (Shared Components\Application Process) Name: ApexLib-Before Computation/Validation
  • Step 10: Open the Shared Components/Templates/Page/[your error page template] and go to the Error Page Template Control section. Paste the following HTML code

Files added/changed:

• ApexLib_Lov.js [ Diff ]
• ApexLib_Field.js [ Diff ]
• ApexLib_Error.js [ Diff ]
• ApexLib.css [ Diff ]
• ApexLib_Item.pkb [ Diff ]
• ApexLib_Item.pks [ Diff ]
• ApexLib_Util.pkb [ Diff ]
• ApexLib_TabForm.pkb [ Diff ]
• ApexLib_TabForm.pks [ Diff ]
• ApexLib_PageFlowDiagram.pks [ Diff ]
• ApexLib_Lov.pkb [ Diff ]
• ApexLib_Browser.pkb [ Diff ]
• ApexLib_views_for_apex_views_22.sql [ Diff ]
• ApexLib_views_for_apex_views_30.sql [ Diff ]
• ApexLib_views_for_apex_tables.sql [ Diff ]
• ApexLib_Core.js [ Diff ]
• ApexLib_Convert.js [ Diff ]
• ApexLib_Validation.js [ Diff ]

• CR# 1683676: Tabular form validations based on dynamic SQL
• CR# 1685427: Support "multi select list" as master for a cascading lov
• CR# 1690927: Don't show required warning when leaving empty field
• CR# 1691701: Popup Lov should also work as master for cascading lov
• CR# 1692584: Support for APEX 3.0 "Date Picker using item format mask"
• Bug# 1690057: Don't do any checks if a Tab is clicked
• Bug# 1684235: addApexValidationErrors doesn't work for Page Level Val.
• Bug# 1686233: Edit Links not displayed in APEX 3.0

Upgrade instructions:

• Follow the steps in the Upgrade section of the How To Install document.
• Follow the revised steps in the "Integration into your Application" chapter of the How To Integrate document:
  • Step 12: Popup List of Values template

Files added/changed:

• ApexLib_Compressed.js [ Changed ]
• ApexLib_Core.js [ Diff ]
• ApexLib_Field.js [ Diff ]
• ApexLib_Validation.js [ Diff ]
• ApexLib_Lov.js [ Added ]
• ApexLib_Browser.pks [ Diff ]
• ApexLib_Browser.pkb [ Diff ]
• ApexLib_Error.pkb [ Diff ]
• ApexLib_TabForm.pkb [ Diff ]
• ApexLib_Lov.pkb [ Diff ]
• ApexLib_Sql_for_apexlib_schema.pkb [ Diff ]
• ApexLib_Sql_for_application_schema.pkb [ Diff ]
• ApexLib_Page.pkb [ Diff ]
• ApexLib_Util.pkb [ Diff ]
• ApexLib_views_for_apex_views_22.sql [ Diff ]
• ApexLib_views_for_apex_views_30.sql [ Diff ]
• ApexLib_views_for_apex_tables.sql [ Diff ]

• CR# 1683243: Page Flow Diagram Generator should work with repository views
• CR# 1683306: Support for other Report Column Headings then "Custom"
• Bug# 1663904: Placeholders in user defined messages are not replaced
• Bug# 1679309: Error in ApexLib_Item if $APEXLIB_IGNORE_VALIDATION$ is set
• Bug# 1680244: View APEXLIB_V_PAGE_ITEM very slow with APEX 3.0
• Bug# 1680250: Update the patched V and NV functions to APEX 3.0

Upgrade instructions:

• Follow the steps in the Upgrade section of the How To Install document.
• If you have installed the drop-in replacements for the V- and NV function, you have to reinstall them (ApexLib_V_functions_patch.sql) in the case you are doing the upgrade to APEX 3.0!

Files added/changed:

• ApexLib_Util.pks [ Diff ]
• ApexLib_Util.pkb [ Diff ]
• ApexLib_Item.pkb [ Diff ]
• ApexLib_views_for_apex_views_22.sql [ Diff ]
• ApexLib_views_for_apex_views_30.sql [ Add ]
• ApexLib_views_for_apex_tables.sql [ Diff ]
• ApexLib_TabForm.pkb [ Diff ]
• ApexLib_PageFlowDiagram.pks [ Diff ]
• ApexLib_PageFlowDiagram.pkb [ Diff ]
• ApexLib_Sql.pks [ Diff ]
• ApexLib_Sql_for_apexlib_schema.pkb [ Diff ]
• ApexLib_Sql_for_application_schema.pkb [ Diff ]
• ApexLib_Validation.pkb [ Diff ]
• ApexLib_V_functions_patch.sql [ Diff ]
• Utl_File_Placeholder.pks [ Added ]
• Utl_File_Placeholder.pkb [ Added ]

• CR# 1673663: Min/Max value check
• CR# 1670687: Use new jQuery 1.1.2 version
• CR# 1674427: Include Feature Demonstration application
• Bug# 1663904: JavaScript error if cascading lov field isn't rendered
• Bug# 1666334: Cascading lov doesn't work for items on page 0
• Bug# 1667049: Browser validation fails for format FM999G999G990D00
• Bug# 1666860: cascading lov not working when bind variables are used twice
• Bug# 1667490: Cascading lov raises javascript error on IE
• Bug# 1669345: Max Length feature for TabForms isn't checked in IE
• Bug# 1670168: Index NULL error if region name isn't unique
• Bug# 1670770: Userdefined onBlur/onChange events have a wrong "this"
• Bug# 1671284: The server side validation checks required for hidden items
• Bug# 1666408: Wrong tabular form column validated in some cases
• Bug# 1671956: Code in body onload isn't executed

Upgrade instructions:

• Re-install database part as described in the How To Install document.
• Include/Copy jquery_Compressed.js and ApexLib_Compressed.js as described in the How To Integrate document.

Files added/changed:

• jquery.js [ Diff ]
• jquery_Compressed.js [ Changed ]
• ApexLib_Compressed.js [ Changed ]
• ApexLib_Core.js [ Diff ]
• ApexLib_Convert.js [ Diff ]
• ApexLib_Field.js [ Diff ]
• ApexLib_Validation.js [ Diff ]
• ApexLib.pks [ Added ]
• ApexLib_Validation.pks [ Added ]
• ApexLib_Validation.pkb [ Added ]
• ApexLib_Browser.pks [ Diff ]
• ApexLib_Browser.pkb [ Diff ]
• ApexLib_Error.pkb [ Diff ]
• ApexLib_Item.pks [ Diff ]
• ApexLib_Item.pkb [ Diff ]
• ApexLib_Lov.pkb [ Diff ]
• ApexLib_Page.pkb [ Diff ]
• ApexLib_TabForm.pkb [ Diff ]
• ApexLib_TabForm.pks [ Diff ]
• ApexLib_Region.pkb [ Diff ]
• ApexLib_Item.pkb [ Diff ]
• ApexLib_Item.pks [ Diff ]
• ApexLib_Util.pks [ Diff ]
• ApexLib_Util.pkb [ Diff ]
• ApexLib_Sql.pks [ Diff ]
• ApexLib_Sql_for_apexlib_schema.pkb [ Diff ]
• ApexLib_Sql_for_application_schema.pkb [ Diff ]

• Bug# 1657465: Some date formats with a slash are handled incorrect
• Bug# 1657820: Page Item which isn't assigned to a region raises ORA-20555
• Bug# 1657853: HowTo Integrate: Error Handling example is wrong
• Bug# 1658232: Error if $APEXLIB_MAX_LENGTH=xx$ is not first hint
• Bug# 1658232: setLRButtonIconsNonNavigable doesn't work for all themes
• Bug# 1655635: FF: Date Picker/Lov icon is navigable after click onto icon
• Bug# 1630138: Error on error page sometimes visible for a blink
• Bug# 1655630: jQuery doesn't work with Safari

Upgrade instructions:

• Follow the revised steps in the How To Integrate document.
• Chapter 1 "Database installation": Call the install scripts or manually install the the changed packages/views.
• Chapter 3 "Integration into your Application", point 3 (ApexLib - Before footer): ApexLib_Browser.setLRButtonIconsNonNavigable has new parameters
• Chapter 3 "Integration into your Application", point 4 (ApexLib - Handle Error Page): apexlib.error.DISPLAY_LOCATION referenced a wrong constant
• Chapter 3 "Integration into your Application", point 10 (Error Page Template Control section): replace with new HTML code

Files added/changed:

• jquery_Compressed.js [ Added ]
• jquery_Compressed.js [ Changed ]
• ApexLib_Compressed.js [ Changed ]
• ApexLib_UI.js [ Diff ]
• ApexLib_views_for_apex_tables.sql [ Diff ]
• ApexLib_views_for_apex_views.sql [ Diff ]
• ApexLib_Browser.pks [ Diff ]
• ApexLib_Browser.pkb [ Diff ]
• ApexLib_Item.pkb [ Diff ]

• CR# 1629371: Add resizeable textarea
• CR# 1645472: Add "Upper/Lower/Capitalize" property for page items/tab form columns
• CR# 1634731: Make lov/date picker icon non keyboard navigable
• CR# 1653552: Make L/R link of image button non keyboard navigable
• CR# 1634729: Function key to open popup lov or date picker
• CR# 1654314: Use Up/Down key for tabular form record navigation
• CR# 1645467: Allow to set "Maximum Width" for tabular form columns
• CR# 1628605: Add method to hide the select all row selector checkbox for tabular forms
• CR# 1651834: Compress the JavaScript library
• CR# 1653079: Use region name instead of fixed string "region source"
• CR# 1654432: Improve HowTo Integrate
• Bug# 1653389: Cascading lov should escape the result

Upgrade instructions:

• Follow the revised steps in the How To Integrate document.
• Chapter 2 "Application Server Installation"
• Chapter 3 "Integration into your Application", point 2 (including the JavaScript library) and point 3 (adding the ApexLib calls)

Files added/changed:

• ApexLib_Compressed.js [ Added ]
• jquery_Compressed.js [ Added ]
• ApexLib.css [ Added ]
• size_grip.png [ Added ]
• ApexLib_Core.js [ Diff ]
• ApexLib_Convert.js [ Diff ]
• ApexLib_Field.js [ Diff ]
• ApexLib_Error.js [ Diff ]
• ApexLib_Validation.js [ Diff ]
• ApexLib_UI.js [ Added ]
• ApexLib_Browser.pks [ Diff ]
• ApexLib_Browser.pkb [ Diff ]
• ApexLib_Item.pks [ Diff ]
• ApexLib_Item.pkb [ Diff ]
• ApexLib_TabForm.pks [ Diff ]
• ApexLib_TabForm.pkb [ Diff ]
• ApexLib_views_for_apex_tables.sql [ Diff ]
• ApexLib_views_for_apex_views.sql [ Diff ]
• ApexLib_PageFlowDiagram.pkb [ Diff ]
• ApexLib_Lov.pkb [ Diff ]
• ApexLib_Compressed1.js [ Deleted ]
• ApexLib_Compressed2.js [ Deleted ]