Inside Oracle APEX by Patrick Wolf

Setting a "Case Restriction" for Page Items/Tabular Form Columns

That’s the last posting about new features in the 1.02 release of the ApexLib Framework. Ever wanted to set a case restriction (uppercase/lowercase/capitalize) for a field like you can do it in Oracle*Forms with the “Case Restriction” property? Here you go!

Continue reading...

Restrict input length of Tabular Form columns

One problem with Tabular Form Column is that they don’t have a “Maximum Width” property as Page Items do. APEX automatically generates a maxlength=2000 for all columns. What is the result? The user gets a when he enters a too long value. Not really nice, isn’t it? And now he has to start counting so that [...]

Continue reading...

One small step for a man, one giant leap for mankind

Just kidding I was just looking for an eye catcher… Maybe you have already seen my announcement that I have released v0.17 of the ApexLib Framework, which contains a lot new features. The previous features in the Framework mostly concentrated on improvements of Oracle APEX on the server, so that’s easier to access Tabular Forms [...]

Continue reading...

ApexLib: Automatic required and date picker/format mask check for page items

Have you ever wondered why you have to create extra validations for required items (item is NOT NULL), for date picker items (item is a valid date) or for numeric items where you have already specified a numeric format mask?

Continue reading...