Tuesday, December 22, 2009

Good old news

This morning I received an email from Oracle's Profit Online newsletter with the top 10 stories of this year. Although it's old news, it's always nice to read some success stories about APEX, especially when it's on number 1.

Applications Express: A Crash Course in Modernization

With 4.0, I expect more of such stories to appear!

Tuesday, December 8, 2009

APEX Plug-Ins

It's almost 2010, and we all know that 4.0 is going to be the version which will change the future..... Well, a particular aspect of it is very promising. I'm talking about the new Plug-In structure of APEX 4.0. It reminds me of the old Delphi possibilities.

For this purpose I started the APEX Plug-Ins group on linkedIn:

This group is for Oracle Application Express (APEX) enthusiasts with the focus on APEX Plug-Ins. The purpose is to share knowledge, tips & tricks and keep each other informed about all the Plug-Ins out there.
We think it is about time to gather ideas for Plug-Ins (using this cool collaboration tool). So don't be shy, start discussions and add your ideas about the Plug-Ins you think you could use (or even create yourself !) or are just very cool....


Sunday, November 22, 2009

Highlight current selected record

If you want to easily highlight the current selected record, you should adapt some standards.
  • Use an id column in every table.
  • Always use a Px_id field on every page with a report, where x is the number of the page.
  • Make a report column template with the desired background color for the highlighted row.
  • The pl/sql expresion condition for this template:  
    • #ID# = v('P'||:APP_PAGE_ID||'_ID')