| Subject | Creating exceptions to handle CHECK constraints |
|---|---|
| Author | Raymond Kennington |
| Post date | 2003-04-20T22:32:35Z |
When a certain table is updated, it triggers a cascade of updates in
other tables, many of whose fields might not satisfy their CHECK
constraints.
How is one to distinguish between these so that the user can be
presented with meaningful information?
E.g. Field "Amount Remaining" in Table "Feed Inventory" has become
negative.
TIA
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)
other tables, many of whose fields might not satisfy their CHECK
constraints.
How is one to distinguish between these so that the user can be
presented with meaningful information?
E.g. Field "Amount Remaining" in Table "Feed Inventory" has become
negative.
TIA
--
Raymond Kennington
Programming Solutions
TeamW2W (InfoPower)