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.

Export Trigger?

2 posts in Trigger Last posting was on 2006-08-30 08:16:48.0Z
Kyle Flavell Posted on 2006-08-29 20:46:44.0Z
Reply-To: "Kyle Flavell" <kflavell@rpndocs.com>
From: "Kyle Flavell" <kflavell@rpndocs.com>
Newsgroups: advantage.trigger
Subject: Export Trigger?
Date: Tue, 29 Aug 2006 13:46:44 -0700
Lines: 5
Organization: Riverside Physician Network
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 63.174.194.2
Message-ID: <44f4a6cc@solutions.advantagedatabase.com>
X-Trace: 29 Aug 2006 14:42:52 -0700, 63.174.194.2
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!63.174.194.2
Xref: solutions.advantagedatabase.com Advantage.Trigger:275
Article PK: 1136339

I would like to create a trigger that will export records to a text file.
From what I've seen so far with Advantage databases, this is not possible.
Does anyone have any suggestions? Thanks!


Joachim Duerr (ADS Support) Posted on 2006-08-30 08:16:48.0Z
From: "Joachim Duerr (ADS Support)" <jojo.duerr@gmx.de>
Subject: Re: Export Trigger?
Newsgroups: Advantage.Trigger
References: <44f4a6cc@solutions.advantagedatabase.com>
Organization: iAnywhere
User-Agent: XanaNews/1.18.1.2
X-Face: ,QMv7[luB)BpWAQ~:"kw6n%0ieY63.:g2K3n~8ky0;||5Xle*Xq+=~<Fy:0CVC2nx@8~vZ
MIME-Version: 1.0
Content-Type: text/plain; charset=iso-8859-1
NNTP-Posting-Host: 195.2.185.25
Message-ID: <44f53b60@solutions.advantagedatabase.com>
Date: 30 Aug 2006 01:16:48 -0700
X-Trace: 30 Aug 2006 01:16:48 -0700, 195.2.185.25
Lines: 14
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!195.2.185.25
Xref: solutions.advantagedatabase.com Advantage.Trigger:276
Article PK: 1136342


Kyle Flavell wrote in <44f4a6cc@solutions.advantagedatabase.com>:

> I would like to create a trigger that will export records to a text
> file. From what I've seen so far with Advantage databases, this is
> not possible. Does anyone have any suggestions?

you need to write the trigger code as a DLL/Assembly/so rather than
using SQL. What you need is not possible with SQL in ADS.

--
Joachim Duerr
Senior Product Support Analyst (Advantage Database Server)
iAnywhere Solutions / Extended Systems
advantage[AT]extendsys.de