EnforceConstraints, CachedUpdates and named constraint

knud

Member
I have a dataset with EnforceConstraints and CachedUpdates on a table with a named constraint on a column. On commit this constraint works well. however, I want to test the constraint after the user stopped editing the value (e.g. after exiting the TdbGrid row or field).
How can I achieve this?
 
Last edited:
With CachedUpdates, if OracleDictionary.EnforceConstraints is True then the constraints will be checked when the new or edited record is posted.
 
Thank you for your help Marco,
I think the problem I encountered is that my check constraint on the table (regexp_like('', column_name)) only works for inserts, even when editing from the PL\SQL developer.
I don't know why that is so, but it means that I will have to use a trigger to force integrety (I must have valid regular expressoins in that column).
I will lose the nice EnforceConstraints possibility, but it seems to be an Oracle thing, not a DOA thing.
 
Last edited:
Back
Top