Trigger Help

Kurt Schafer ( (no email) )
Fri, 18 Sep 1998 22:41:26 -0400

This is a multi-part message in MIME format.

------=_NextPart_000_0006_01BDE355.7879B790
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

I'm trying to make a trigger that updates a new table whenever an INSERT =
occurs in SubAccounts.

I've made the new table with replica fields that I want the trigger to =
duplicate (I don't need a duplicate of every field) but I can't seem to =
work the trigger properly to insert the desired data into the new table.

Can anybody help me out ? For example, how could I make a trigger to =
copy Login,Password FROM SubAccounts into NewTable on INSERT into =
SubAccounts ?

TIA

=3D K

------=_NextPart_000_0006_01BDE355.7879B790
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">

I'm trying to make a trigger that =updates a new=20table whenever an INSERT occurs in SubAccounts.
 
I've made the new table with replica =fields that=20I want the trigger to duplicate (I don't need a duplicate of every =field) but I=20can't seem to work the trigger properly to insert the desired data into =the new=20table.
 
Can anybody help me out ? For =example, how could=20I make a trigger to copy Login,Password FROM SubAccounts into NewTable =on INSERT=20into SubAccounts ?
 
TIA
 
=3D K
------=_NextPart_000_0006_01BDE355.7879B790--