Hi,
can someone tell how to write a Trigger; I am familiar with Sybase Sql
Anywhere trigger syntax.
Actually I have three tables MEMBER, CONTRACT and PAYMENT

I need to update the MEMBER.BALANCE once the PAYMENT.AMOUNT is INSERTED
where PAYEMENT.CONTRAC_ID = CONTRACT.CONTRAC_ID
and CONTRAT.MEMBER_ID = MEMBRE.MEMBER_ID

I have more TRIGGERS to write, but with a good example it would be great

In fact, send me as many examples as you can

Thanks

Fernand

fernand.st-georges (AT) videotron (DOT) ca

See the documentation at http://sybooks.sybase.com/as.html
the Transact-SQL User's Guide. There is a chapter on triggers with multiple
examples.
"Fernand St-Georges" <fernand.st-Georges (AT) videotron (DOT) ca> wrote

Big guy, sorry to be so blunt, but have you tried RTFM? Sybase is
superbly documented.

;-)

Steve

On Wed, 21 Jan 2004 17:24:28 -0500, "Fernand St-Georges"
<fernand.st-Georges (AT) videotron (DOT) ca> wrote: