Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

trigger type

2 posts in General Discussion Last posting was on 2008-11-09 23:49:16.0Z
Alex Posted on 2008-11-09 23:00:48.0Z
Sender: 1ec8.49176a64.1804289383@sybase.com
From: Alex
Newsgroups: ianywhere.public.general
Subject: trigger type
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49176ba0.1eef.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 9 Nov 2008 15:00:48 -0800
X-Trace: forums-1-dub 1226271648 10.22.241.41 (9 Nov 2008 15:00:48 -0800)
X-Original-Trace: 9 Nov 2008 15:00:48 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7140
Article PK: 5361

hi

is any way to get trigger-type(insert,delete,update) when
trigger fired or it's only one way to write a 3 separated
triggers?


Chris Keating (Sybase iAnywhere) Posted on 2008-11-09 23:49:16.0Z
From: "Chris Keating (Sybase iAnywhere)" <keating_spam_free@ianywhere.com>
User-Agent: Thunderbird 2.0.0.17 (Windows/20080914)
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: trigger type
References: <49176ba0.1eef.1681692777@sybase.com>
In-Reply-To: <49176ba0.1eef.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <491776fc$1@forums-1-dub>
Date: 9 Nov 2008 15:49:16 -0800
X-Trace: forums-1-dub 1226274556 10.22.241.152 (9 Nov 2008 15:49:16 -0800)
X-Original-Trace: 9 Nov 2008 15:49:16 -0800, vip152.sybase.com
Lines: 30
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7141
Article PK: 5359

Look for trigger "operation conditions" - the following reference is
from the SA11 documentation:

SQL Anywhere Server - SQL Reference » Using SQL » SQL language elements
» Search conditions » Trigger operation conditions


--

Chris Keating

****************************************
Please only post to the newsgroup

SQL Anywhere Developer Community
http://www.sybase.com/developer/library/sql-anywhere-techcorner
SQL Anywhere Blog Center
http://www.sybase.com/sqlanyblogs
Maintenance releases and EBFs
http://downloads.sybase.com/swx/sdmain.stm
Use Case Express to report bugs
http://case-express.sybase.com

Alex wrote:
> hi
>
> is any way to get trigger-type(insert,delete,update) when
> trigger fired or it's only one way to write a 3 separated
> triggers?