Hi, I have one problem.When I have defined trigger before update on some table, then update was succesfully performed but updatedvalue haven\'t changed, his value is old!This effect has been althrough trigger function do not perform any operation.If I drop trigger before update, then update was performed OK! Why? Where is the problem? Help. Thanks
On Thu, 28 Nov 2002, Richard Lukacik wrote: > I have one problem.When I have defined trigger before update on some > table, then update was succesfully performed but updated value > haven\'t changed, his value is old!This effect has been althrough > trigger function do not perform any operation. If I drop trigger > before update, then update was performed OK! Why? Where is the > problem? You haven't sent the trigger, so it's hard to say, but I'd guess that you might be returning either OLD or NULL from the trigger.
Сайт использует файлы cookie для корректной работы и повышения удобства. Нажимая кнопку «Принять» или продолжая пользоваться сайтом, вы соглашаетесь на их использование в соответствии с Политикой в отношении обработки cookie ООО «ППГ», в том числе на передачу данных из файлов cookie сторонним статистическим и рекламным службам. Вы можете управлять настройками cookie через параметры вашего браузера