Subject | error when try check inactive |
---|---|
Author | adrimnet |
Post date | 2008-10-09T18:03:12Z |
hello to everybody,
sorry for my bak english.
I have a check constraint (check_3) in a table like this (check
totaldiscount>-1)
I need inactive this check and run this instruction
alter trigger check_3 inactive
firebird return an error:
MODIFY TRIGGER failed
action cancelled by trigger (1) to preserve data integrity
Cannot update trigger used a CHECK constraint.
Somebody helps me.
Thanks
sorry for my bak english.
I have a check constraint (check_3) in a table like this (check
totaldiscount>-1)
I need inactive this check and run this instruction
alter trigger check_3 inactive
firebird return an error:
MODIFY TRIGGER failed
action cancelled by trigger (1) to preserve data integrity
Cannot update trigger used a CHECK constraint.
Somebody helps me.
Thanks