APEX ITEM and Dynamic Tabular Forms - Amazon Web PDF
Preview APEX ITEM and Dynamic Tabular Forms - Amazon Web
APEX_ITEM and Dynamic Tabular Forms Greg Jarmiolowski SQLPrompt LLC Agenda • Tabular Form Creation • Tabular Form Post Processing Built-ins • Building Forms with APEX_ITEM • Global Arrays • Custom Post processing • APEX_COLLECTIONS • Validation • Locking and Concurrency What Are Tabular Forms • Forms for editing multiple records at once • Attribute pairs/many to many list management • Questions and answers • The detail for a master detail relationship Example Form How To Create A Tabular Form • Wizard • “Tabular Form Element” attributes of the report columns SQL Query (updatable report) • SQL report using APEX_ITEM • PL/SQL region using APEX_ITEM Using The Wizard • 12+ steps – no shortcuts • Automatically generates CRUD processes • Add rows feature • Handles Concurrency (quite ugly) • With some tweaking should handle majority of forms Built in Update Built in Insert Built in Lost Update Detection • Wizard creates a checksum field for records • MRU process compares this on post • Results are uncontrollable and not good Column Attributes
Description:The list of books you might like
