Trigger won't work

#11

Pablo Sanchez wrote:

Quote:

Daniel Morgan <damorgan@x.washington.edu> wrote in
news:1075995577.782758@yasure:

Can anyone make a definitive statement as to which versions of
Sybase have BEFORE triggers and which do not?

There are two DB products:

- ASE
- ASA

You need to re-ask your question.

Ok ... which products sold by Sybase (the company) have BEFORE triggers
in their current versions?

Does that suffice?

Thanks.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

#12

Bret Halford wrote:

Quote:

"Michael Peppler" <mpeppler (AT) peppler (DOT) org> wrote

On Thu, 05 Feb 2004 07:40:31 -0800, Daniel Morgan wrote:

Can anyone make a definitive statement as to which versions of Sybase have
BEFORE triggers and which do not?

ASEnterprise does NOT have BEFORE triggers through 12.5.0.x. I haven't
checked, but I don't think they are in 12.5.1 either.

BEFORE triggers may be available in ASAnywhere - but I don't know or use
that product personally.

Michael

ASE 12.5.1 does not have BEFORE triggers either, and I'm not
aware of plans to put them into the next release (15.0). There
is an open feature request for it, CR 338053.

ASA does support BEFORE triggers.

I believe the original trigger can be written for ASE as

CREATE TRIGGER tr_1 on Table1 for INSERT
as
insert Table2 (DUMMIES) select 1 from inserted

Thanks. And by BEFORE trigger, I assume, we both mean that the trigger
fires before constraints are evaluated.

Thanks again.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Trigger won't work

comp.databases.sybase comp.databases.sybase

Re: Trigger won't work - 02-05-2004 , 02:28 PM

Re: Trigger won't work - 02-05-2004 , 02:29 PM