How to handle deferrable constraints

[Sergio Sette]

In my database I have defined some deferrable integrity constraints. These are not applied until the use commits the transaction and not when the record is postes.
Usually i handle database errors with the onPostError event but in this special case the event simply doesn't fires.
What is the best approach to handle errors generated by deferrable constraints ?

Regards

 

[Marco Kalter]

By default each posted record is implicitly committed, so you should still get the exception. If you are using CachedUpdates, the error will occur during TOracleSession.ApplyUpdates.