I started developing applications back in the good (?) old client/server days. I was fortunate enough to discover Delphi quite early. Even from the start, the lowly 16-bit Delphi version 1 had a kick-ass DBGrid control which allowed you to quickly and easily build data-centric applications. Just write a SQL statement in a TDataSet component, connect it to the grid, and voila! Instant multi-row display and editing out of the box, without any coding.
As of version 1.0, the jQGrid for PL/SQL and Apex has the following features:
- Single line of PL/SQL code to render grid
- Populate data based on REF CURSOR or SQL text (with or without bind variables). The REF CURSOR support is based on my REF Cursor to JSON utility package.
- Define display modes (read only, sortable, editable) and edit types (checkbox, textarea, select list) per column
- Store grid configuration in database, or specify settings via code (for read-only grids)
- Ajax updates (insert, update, delete) based on either automatic row processing (dynamic SQL) or against your own package API
- Multiple grids per page
- Integrated logging and instrumentation
- Usable without Apex (for stand-alone PL/SQL Web Toolkit applications) or with Apex, optionally integrated with Apex session security
The jQGrid Integration Kit for PL/SQL is free and open source. Download and try it now!.