Posts

Showing posts from December, 2011

Re-Sequence Tabular Form

Well, a while back I was looking at what's provided in the application builder. On a page with a number of application items - in tree view, if you right click and select Drag & Drop Layout, and then switch tabs to Reorder Items, you are presented with a tabular form. On the far right you'll will see little up and down arrow image icons, and after selecting, allows you to easily move items up or down. This is not something that comes standard, and in my opinion, something that is very useful. Once again, if we look closely, we should be able to easily replicate that functionality. Step one, I will create a table - a common one of the top of my head is statuses, so i will create a status table with 3 columns: status_id, name, sequence: CREATE table "STATUS" ( "STATUS_ID" NUMBER, "NAME" VARCHAR2(20), "SEQUENCE" NUMBER, constraint "STATUS_PK" primary key ("STATUS_ID") ) / CREATE