Oracle & APEX Geekery

Tags van Technorati: apex , dynamic action , tabular form , add row , focus , cursor I just got the question from a fellow developer, how to focus the cursor to the first input field of a newly added row using the ADD button in a standard APEX Tabular Form. Actually, I would expect APEX to do this automagically. But it doesn’t. To implement this behavior is actually really simple.     For this example I create a simple tabular form based on the demo_customers table: This is what the form looks like when you click the “Add Row” button. As you can see, none of the input field has focus at this time. To focus the cursor on the first field of the new row (Cust First Name), I somehow have to change the behavior of the “Add Row” button. Let’s have a look at it’s definition: The click-action of the button is actually a JavaScript call: addRow();. Naturally I want to keep this action, but after this, I want to start an additional action that should set the focus to the input f...

When working with APEX you certainly want to use the APEX Listener. It’s a great piece of software and Oracle is committed to extend its functionality (Oracle recently release the beta version of the new APEX Listener 2.0 ). When installing the APEX Listener, you basically have two choices: run APEX Listener “Standalone” deploy the Listeners WAR file to one of the supported webservers The problem (at least, my problem): when using the APEX Listener on my laptop/desktop with my local APEX instance, I do not want to set up a whole webserver, just to be able to develop APEX applications. So I,’m choosing the lightweight option: Standalone! But the annoying thing about the standalone installation is, that I have to start the APEX Listener from the command line each time I want it to be available. It just would be so much easier to just have it as a Windows service, stating during system boot. Seems that an APEX developer from Poland, Andrzej Nowakowski , solved this problem for us and...

Tonight (CET) the European Football Championship kicks off. As with every EURO or World Championship I’m organizing a predicting game where you (Yes, you too!) can bet on match results FifApex . And again, the website is build with Oracle Application Express. New this year: I created a mobile version of FifApex ( m.fifapex.net ) with APEX and the jQuery Mobile framework. If you want to know how I’ve done this, come visit my presentation at the ODTUG KScope12 conference in San Antonio, Texas , end of this month. Meanwhile, register for FifApex, enter our predictions, and maybe you will be one of the winners of the prizes …     BTW: if you missed the first games: you still can enter the competition AND, from my experience, I can tell you: there is not a lot football/soccer knowledge required for a good ranking ;-).

This article describes a solution to determine the client device category (i.e. desktop, browser or tablet) your APEX application is accessed from. Until recently, building a web application with Oracle Application Express usually meant to build a desktop browser application. But if you look at the growing number of mobile devices, this will change very soon, if not already has for some of you. Being able to develop applications, that can be accessed by tablets or smart phones offers lots of new possibilities. But it also comes with some challenges. Mobile devices are different. Interaction by touch screen, screen size and (non-) support of certain common web functionality (flash, for example), just to mention a few. Oracles announcement to integrate the jQuery mobile framework into APEX 4.2 will help us to deal with many of the challenges, developing for multiple devices will bring. Until now, one of the biggest challenges is, to determine the actual client your application ...

Yesterdays OGh APEX day in Zeist (NL) was a great success. The probably largest APEX-only congress (almost 300 APEX enthusiasts) was packed with 3 parallel tracks of presentations covering a wide variety of APEX related subjects. The OGh organization committee again managed to invite well known APEX experts as speakers: Dimitri Gielis and John Scott (the dynamic APEX Evangelists Duo), Roel Hartman, Alex Nuijten, Patrick Barel (all ACE or ACED so far). Iloon Ellen Wolff, from Oracle NL, gave us some previews on Oracle’s Cloud Service, mostly slides and video’s. A live demo wasn’t possible, because there is something going on at Oracle and we may can expect some exciting news very soon. The highlight, in my eyes, was Patrick Wolf’s keynote presentation, talking about the recent enhancements of 4.1.1,and, much more exciting, giving us a glimpse of what will come in the long awaited 4.2 upgrade. After showing the usual “Oracle Save Harbor Statement” the conference participants wer...

This short article is actually a shameless plug for my new service and website. So, if you are looking for some technical info on APEX: do not read any further. But if you want to provide your APEX application with a custom UI design without having to dive into HTML, CSS scripting and creating graphical components yourself, pay a visit to my brand new website: themes4apex.com. Define I offer to design and implement APEX themes and templates based on your specifications, whatever these are: an existing web page, concepts created in PowerPoint  or any other image reference or prototyping tool. Design I like to keep things simple. So your custom APEX UI design will be based on HTML and CSS, DIV-based and guaranteed to tested and working in all current browser brands and versions. Deliver You will receive your custom theme ready to import into your APEX environment together with a demo application using the theme. Interested? Visit themes4apex and contact me. ...

Due to the overwhelming number of registrations (250+ participants, entirely sold-out) the OGh Apex Day 2011 “Mini” congress had to be relocated to a different, larger location. This states the enormous interest in APEX in the Netherlands. Oracle Application Express is hot in NL. Another reason for the large number of participants (mainly developers) must have been the subjects of the presentations and the lineup of well known and respected (international) speakers: Dimitri Gielis & John Scott, aka the APEX Evangelists, where scheduled for 3 (!) presentations; Hilary Farrel represented the Oracle APEX development team; Roel Hartman and Iloon Ellen Wolf, both known for their high quality APEX presentations; Peter Raganitsch, APEX expert from Vienna and developer of the OpenSource Framework ApexLib. Line-up The OGh Apex Day 2011 was kicked off by Tony Andrews en Nigel Blair from Northgate (UK), presenting their experience with migrating a large Oracle Forms application to APEX. It w...