What type of code to write if NOT NULL messages must be avoided

What type of code must be written to avoid the cryptic NOT NULL messages when records are to be added for fields already defined with NOT NULL in the table definitions?

The NOT NULL message is not that cryptic. It indicates that arequired field, one that is not allowed to be null, does not have a valuewhen the row containing the field is written to the database.

It’s fairly easy to check for this. At the appropriate place, you woulduse the ISNULL() method for the Value property of the fields linked to the table’s NOT NULL columns.

But where is the appropriate place? You have to do it before the row getsto the database. OPO will flush a row to the database in a variety ofcircumstances, such as moving to another container. The whole point ofthis corrective action is to inform users of a problem while they canstill fix it; for me, this means before they navigate to another row. Iwould use the Go… methods for this logic. It probably makes senseto add this logic to a user-defined method and call it from bothGo… methods.

In my new book, Mastering Oracle Power Objects from O’Reilly &Associates, I explain how to create a class that will make this even easierto implement.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin


The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS