Triggers

[JSerrano]

Hi, I have an application with DOA connected to ORACLE. I have a table where 3 fields have the clause "NOT NULL" but there is a trigger that update these fields with special values. The problem is that I want to update these fields with the triggers, not inserting values from me, but an error occurs with the message "Field FEC_ALTA must have a value"

Why doesn

 

[Marco Kalter]

When the dataset creates the field definitions, the Required property of each field is set to True or False, corresponding with the underlying column. Before the record is posted to the database, and therefore before your trigger can set the values, the dataset will check if the required fields have a value.

To circumvent this problem, you can make the fields persistent at design time and set the Required property to False for the fields that are modified by the database trigger. If you don't want to use persistent fields, you can set the Required property to False at runtime after the dataset is opened.

------------------
Marco Kalter
Allround Automations