Hi,
tanks a lot, that worked fine! Only that I can not find any
reference to that syntax in the maxdb manual, maybe there
should be a correction...
Thanks all for the prompt help!
Tobias Dittrich
Am Dienstag, 13. Juli 2004 09:55 schrieb Anhaus, Thomas:
> Tobias Dittrich wrote :
> >Hi,
> >
>
Hello Tobias,
Try this:
CREATE TRIGGER TEST_TIMESTAMP FOR TEST AFTER UPDATE EXECUTE
(
IF (OLD.DATUM <> NEW.DATUM) THEN
RETURN;
UPDATE USER.TEST SET DATUM=TIMESTAMP WHERE TEST.ID=:NEW.ID;
)
and when you make UPDATE don't update tstamp coluumn.
Regards, Dusan.
On Tue, 13 Jul 2004 09:45:06 +02
Hi,
Kernel 7.5.0 Build 014-121-073-298 (just installed the rpm I
got from the mysql download site). From the knldiag I think
there is a segfault (see attached file).
From your questions I assume that this behaviour is
unexpected and my aproach actually goes in the right
direction?
Thanks
Tob
Tobias Dittrich wrote :
>
>Hi,
>
>I have seen this question asked before on this list, but
>unfortunately the answer deviated a bit from the original
>question - or maybe I just did not understand the answer
>good enough, this is the first time I try with triggers and
>such.
>
>I want to do so
Tobias Dittrich wrote:
> Hi,
>
> I have seen this question asked before on this list, but
> unfortunately the answer deviated a bit from the original
> question - or maybe I just did not understand the answer
> good enough, this is the first time I try with triggers and
> such.
>
> I want to do s
Hi,
I have seen this question asked before on this list, but
unfortunately the answer deviated a bit from the original
question - or maybe I just did not understand the answer
good enough, this is the first time I try with triggers and
such.
I want to do something like copy the behaviour of t
