Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Our developers are asking for a way to enforce that a particular field cannot contain any values ( null ), unless another field has a certain value in it ( "S" ).
I assume the only way to do this is to have a pre-insert trigger that calls a stored procedure, but is that right, or is there some way to manipulate a check constraint to do it ?
Thanks,
floyd
Your privacy choices
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.