Change default Date Picker Icon

Written by Paulo Vale on Tuesday, May 27, 2008

So you don't like de default Date Picker icon? The good news is that there a very simply way to change it.


First of all, you need to have a nice icon. I suggest this website where you can find a lot of beautiful and free icons. Now that you have the icon file you need to upload it to your system. If you don't want to upload to the filesystem, you may follow this path "Shared Components>Images>Create Image" and upload it to APEX static files.

Now to set your icon as Date Picker default you need to update your application Theme. Go to the Themes option on Shared Components and edit the default theme. Then, click "Calendar Icon Details" and enter the path to the uploaded image file.




Change the request of a select list with submit

Written by Paulo Vale on Monday, May 26, 2008

Today I had this requirement with a Select List with Submit in a new application I'm developing. I had a form with an Automatic Row Processing (DML), After Submit process. This process is used only for updates and should be triggered when the value of a Select List changes.


I've created the Select List with Submit but the process was not executed. The reason is that by default the request value is the name of the Select List item and as you can see in the previous picture, the data manipulation process will perform a SQL UPDATE only when the request value is one of the listed values (SAVE, APPLY CHANGES, UPDATE, UPDATE ROW, CHANGE, APPLY, APPLY%CHANGES%, GET_NEXT%, GET_PREV%).

To get around this, here is what I did: first I've
changed the item back to a normal Select List and then added the following code to the 'Element > HTML Form Element Attributes' property:

onchange="doSubmit('UPDATE');"
Here is a screenshot of the Select List item properties:


Happy programming :)

Oracle Application Express 3.1.1 patch set was released

Written by Paulo Vale on Thursday, May 22, 2008

Yes it's true, the patch is out. I found it reading Joel Kallman blog. As Joel states in his blog, this not a new APEX version... it is a patch with bug fixes.

One of the things that makes me happy with our decision at Neoface of directing all the development efforts to this technology (APEX) is the frequent updates APEX team is giving us.

They are doing a great job.