Re: triggers

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Wed, 14 Apr 2004 21:56:52 +0200
Message-ID: <c5k4sm$io8$1@news3.tilbu1.nb.home.nl>

Choung wrote:

> I want to clarify what I meant by:
>
>

>>This triggers works but I'm trying to get the trigger to write to my table
>>when there has been an entry made.  I don't want any duplicates either.

>
> Any
>

>>suggestions?

>
>
> I want to get the trigger to write to my table when the entry is made and I
> want it to update my table when chages are made.
>
> thanks,
>
>

Still not clear...
A trigger is something that gets triggered ("fires") when data is written into your table (on insert trigger), or updated (on update trigger).
It does not replace the insert/update, which is the case in some other databases.

-- 

Regards,
Frank van Bortel

Received on Wed Apr 14 2004 - 14:56:52 CDT