DBGrid (DataSet) and triggers

[naotar]

Hi,

I have tables with before update, insert triggers and when i connect OracleDataSet component to DBGrid for inserting, editing data I'm receiving error, its looks that OracleDataSet don't execute events triggers.

Any idea?

Thanks,

Naotar

 

[Marco Kalter]

Before update and insert triggers cannot be circumvented. What exactly is the error?

 

[naotar]

First I will discribe idea of my updates, inserts:

I have several not null fields in tables, that are set in the trigger, also I have triggers to keep history of changes in records (also done by trigger). When I use TOracleDataSet connected to DBGrid for adding some records I'm, reciving error that required field (not null) are not set so OracleDataSet can't commit

 

[Marco Kalter]

You will need to set the Required property of these fields to false, either at design time (if you are using persistent fields) or at run time.

If you are not using persistent fields, you can also set TOracleDataSet.OracleDictionary.RequiredFields to False. Now all TField.Required properties will be False at run time.

Note that you will probably need to include roAfterInsert and maybe roAfterUpdate in the RefreshOptions of this dataset. This way the dataset will immediately be updated with the values generated by the trigger.