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.

need good Trigger Examples!

2 posts in General Discussion Last posting was on 2004-03-12 14:17:41.0Z
Matani Posted on 2004-03-12 13:20:07.0Z
Reply-To: "Matani" <S.Matani@ads-tec.de>
From: "Matani" <saleh@matani.net>
Newsgroups: ianywhere.public.general
Subject: need good Trigger Examples!
Lines: 13
Organization: *
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: gabriel.le1.ads-tec.de
X-Original-NNTP-Posting-Host: gabriel.le1.ads-tec.de
Message-ID: <4051b907@forums-1-dub>
Date: 12 Mar 2004 05:20:07 -0800
X-Trace: forums-1-dub 1079097607 62.153.239.43 (12 Mar 2004 05:20:07 -0800)
X-Original-Trace: 12 Mar 2004 05:20:07 -0800, gabriel.le1.ads-tec.de
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2776
Article PK: 6244

hello ,
i am searching for a good Trigger Examples for Delete Trigger,
i am tring to write a Trigger on Database 7.0 that write a row in other
Table bevor Delete and to write also in the column "Deleted" = 1.
the column "Deleted" dose bot exist in the Orginal table!

in History Table is Deleted=0 as standard

thank you

Matani


Reg Domaratzki Posted on 2004-03-12 14:17:41.0Z
From: "Reg Domaratzki" <Spam_bad_rdomarat@ianywhere.com>
Newsgroups: ianywhere.public.general
References: <4051b907@forums-1-dub>
Subject: Re: need good Trigger Examples!
Lines: 32
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: rdomarat-pc.sybase.com
X-Original-NNTP-Posting-Host: rdomarat-pc.sybase.com
Message-ID: <4051c685$1@forums-1-dub>
Date: 12 Mar 2004 06:17:41 -0800
X-Trace: forums-1-dub 1079101061 172.31.143.163 (12 Mar 2004 06:17:41 -0800)
X-Original-Trace: 12 Mar 2004 06:17:41 -0800, rdomarat-pc.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:2777
Article PK: 6245

I don't understand what you're trying to do.

Are you trying to prevent the delete from occurring in the base table and
instead change the value of the deleted column in the base to 1, then at the
same time write the row in the history table?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

"Matani" <saleh@matani.net> wrote in message news:4051b907@forums-1-dub...
> hello ,
> i am searching for a good Trigger Examples for Delete Trigger,
> i am tring to write a Trigger on Database 7.0 that write a row in other
> Table bevor Delete and to write also in the column "Deleted" = 1.
> the column "Deleted" dose bot exist in the Orginal table!
>
> in History Table is Deleted=0 as standard
>
> thank you
>
> Matani
>
>