i get a SFieldRequired error messages when i apply data via TOracleDataset. there is a not null field ID. but i set this field in the before update trigger of the table in oracle so it's ok that it is null when i apply the data (it's ok for me, not for doa [Linked Image])

i use delphi5, TOracleDataset via midas. LockingMode is lmLockImmediate, RefreshOptions are [roBeforeEdit,roAfterInsert,roAfterUpdate,roAllFields].

i get the error: field 'ID' required (don't know how exactly in english, in german: Feld 'NR' mu

You must either set the Required property of this field to False, or you must set TOracleDataSet.OracleDictionary.RequiredFields to False if you don't want to use persistent fields. In any other case the TDataSet will not allow you to post the record as long as any required field is null.

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

thanks for your quick reply.

ralf