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.

how to access sql statement in trigger

2 posts in General Discussion Last posting was on 2002-12-09 14:19:18.0Z
vitaliy_davydov Posted on 2002-12-06 16:49:55.0Z
From: vitaliy_davydov
Date: Fri, 6 Dec 2002 11:49:55 -0500
Newsgroups: ianywhere.public.general
Subject: how to access sql statement in trigger
Message-ID: <8085F4381350169E005C75F785256C87.005C760685256C87@webforums>
Lines: 5
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub ianywhere.public.general:391
Article PK: 2212

We're running ASA 8.
When on-delete trigger is fired, I'd like to save the delete sql statement
in another table. Is it possible to get a hold of the statement in the
trigger?

Appreciate any ideas.


Robert Waywell Posted on 2002-12-09 14:19:18.0Z
From: "Robert Waywell" <rwaywell@ianywhere.com>
References: <8085F4381350169E005C75F785256C87.005C760685256C87@webforums>
Subject: Re: how to access sql statement in trigger
Date: Mon, 9 Dec 2002 09:19:18 -0500
Lines: 34
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
Message-ID: <rh6iUB5nCHA.199@forums.sybase.com>
Newsgroups: ianywhere.public.general
NNTP-Posting-Host: 172.31.143.74
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub ianywhere.public.general:388
Article PK: 2207

Please do not cross post. This question has been answered in the
sybase.public.sqlanywhere.general newsgroup.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://casexpress.sybase.com/cx/cx.stm

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the iAnywhere
Developer Community at www.ianywhere.com/developer

<vitaliy_davydov> wrote in message
news:8085F4381350169E005C75F785256C87.005C760685256C87@webforums...
> We're running ASA 8.
> When on-delete trigger is fired, I'd like to save the delete sql statement
> in another table. Is it possible to get a hold of the statement in the
> trigger?
>
> Appreciate any ideas.