Disabling Interactive Grid Columns

I’ve seen various information about how to disable IG columns, either through read-only attributes, using special classes and other nifty tricks. But thinking simply about this … a column should either be conditionally removed at page load or dynamically controlled – and what should we use for dynamic controls? Dynamic Actions. There’s an example on Page […]

APEX, APEX 5.1 Interactive Grid / May 14, 2018

Read More

Interactive Grid – First Impressions

I recently joined Explorer from 4 years as an APEX 4.2 Developer on a variety of projects. I looked forward to using Interactive Grid (IG) – from APEX 5.1 onwards – and it is good to see APEX progressing and developing new features such as this. It looked a fast and easy way of streamlining […]

APEX 5.1 Interactive Grid / May 3, 2018

Read More

Getting to Grips with the APEX Interactive Grid API

Whilst attending Tech17 at Birmingham this year, I was pleased to see David Peake provide a short demonstration of the Oracle Interactive Grid API documentation. The documentation format/style, using JSDoc, differs from the traditional APEX documentation style we are used to. However, from the quick demo I saw, it does look great, and I cannot […]

APEX 5.1, Blog APEX 5.1, Interactive Grid / December 8, 2017

Read More

Validations and Duplicate Page Submissions in APEX 5.1

I had a problem with a modal dialog page in APEX 5.1, which created new rows in a table on the database whenever the Create button was pressed. The problem was that if the user was very quick i.e. double/triple clicking on the Create button, then it was possible to create duplicate rows on the […]

APEX, APEX 5.1, Blog Validation / October 9, 2017

Read More

QuickSQL – Saves you time

One of the new features of APEX 5.1 definitely changed my way of creating DDL on Oracle databases. With the Quick SQL packaged application you only need to write minimal lines of markdown text to describe tables, triggers, audit tables and many other objects. This low code development concept can save you so much time, […]

APEX 5.1, Blog, Low Code / September 19, 2017

Read More

Moving to the Cloud: A Developer’s Perspective

I have been recently working with a charity who had developed a production APEX application and hosted it on apex.oracle.com. While this environment is brilliant for quickly creating a full APEX workspace and accessing from anywhere in the world, it is definitely not supposed to be used to host a production application (the environment can […]

APEX 5.1, Blog, Cloud, Explorer Cloud, Oracle Cloud / August 7, 2017

Read More

Presentation: A Review of Interactive Grid in APEX 5.1.1

Following on from my blog A Review of Interactive Grid in APEX 5.1.1; I presented a version of this at Scotland UKOUG event in June 2017. At the heart of this presentation; I wanted to discover more about what the User and Developer perspectives of this new region type were. For example; I wanted to […]

APEX 5.1, Blog / June 26, 2017

Read More

Client Side Validations

Since using APEX 5.1, you may have noticed a few differences in regards to client side validation when using a combination of: Compatibility Mode = 5.1 and Execute Validations on Buttons = Yes What you may have noticed is that client side validations are firing first; and only if the page is successfully validated will […]

APEX 5.1, Blog / June 2, 2017

Read More

A Review of Interactive Grid in APEX 5.1.1

A Review of Interactive Grid in APEX 5.1.1 This blog has been a long time in the making… Of course before writing a blog on any subject, you have to do your research. In my case, my research involved creating dozens (maybe in to the 100s) of Interactive Grids (IG) and writing a new Explorer […]

APEX 5.1, How to, Review APEX 5.0, Development, Interactive Grid, reporting, upgrade / March 29, 2017

Read More

Dynamic Theme Style in APEX 5.1

Dynamic Theme Style in APEX 5.1 One of the new features of APEX 5.1 is the introduction of APEX_THEME API which enables you to change the application theme style by user. A very nice APEX 5.0 feature is to allow users to change the theme style using the APEX_UTIL.SET_CURRENT_THEME_STYLE procedure (deprecated in 5.1) but this change […]

APEX 5.1, Explorer, How to Development, Style, Universal Theme / March 28, 2017

Read More

Next Page »

Featured Posts