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.

Maximum container size of a SQL based trigger

3 posts in Trigger Last posting was on 2006-03-14 06:17:03.0Z
Thomas Steinmaurer Posted on 2006-03-13 19:06:39.0Z
Date: Mon, 13 Mar 2006 20:06:39 +0100
From: Thomas Steinmaurer <t.steinmaurer_dontbugmewithspam_@upscene.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Maximum container size of a SQL based trigger
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 86.56.177.91
Message-ID: <4415c1e6@solutions.advantagedatabase.com>
X-Trace: 13 Mar 2006 12:03:02 -0700, 86.56.177.91
Lines: 17
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.56.177.91
Xref: solutions.advantagedatabase.com Advantage.Trigger:199
Article PK: 1136264

Hello,

someone evaluating ADS LogManager has a problem on creating a trigger on
a particular table. Is there a maximum container size for a SQL based
trigger?

Thank you.

--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com


Alex Wong (ADS) Posted on 2006-03-14 00:08:59.0Z
From: "Alex Wong \(ADS\)" <alexw@extendsys.com>
Newsgroups: Advantage.Trigger
References: <4415c1e6@solutions.advantagedatabase.com>
Subject: Re: Maximum container size of a SQL based trigger
Date: Mon, 13 Mar 2006 17:08:59 -0700
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 198.102.102.38
Message-ID: <441607ca@solutions.advantagedatabase.com>
X-Trace: 13 Mar 2006 17:01:14 -0700, 198.102.102.38
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.38
Xref: solutions.advantagedatabase.com Advantage.Trigger:200
Article PK: 1136267

The maximum size of SQL script for trigger is 64K.

Alex

"Thomas Steinmaurer" <t.steinmaurer_dontbugmewithspam_@upscene.com> wrote in
message news:4415c1e6@solutions.advantagedatabase.com...
> Hello,
>
> someone evaluating ADS LogManager has a problem on creating a trigger on a
> particular table. Is there a maximum container size for a SQL based
> trigger?
>
> Thank you.
>
> --
> Best Regards,
> Thomas Steinmaurer
> LogManager Series - Logging/Auditing Suites supporting
> InterBase, Firebird, Advantage Database, MS SQL Server and
> NexusDB V2
> Upscene Productions
> http://www.upscene.com
>


Thomas Steinmaurer Posted on 2006-03-14 06:17:03.0Z
Date: Tue, 14 Mar 2006 07:17:03 +0100
From: Thomas Steinmaurer <t.steinmaurer_dontbugmewithspam_@upscene.com>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: Advantage.Trigger
Subject: Re: Maximum container size of a SQL based trigger
References: <4415c1e6@solutions.advantagedatabase.com> <441607ca@solutions.advantagedatabase.com>
In-Reply-To: <441607ca@solutions.advantagedatabase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 86.56.177.91
Message-ID: <44165f02@solutions.advantagedatabase.com>
X-Trace: 13 Mar 2006 23:13:22 -0700, 86.56.177.91
Lines: 8
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!86.56.177.91
Xref: solutions.advantagedatabase.com Advantage.Trigger:201
Article PK: 1136266

> The maximum size of SQL script for trigger is 64K.

Thanks for the confirmation, Alex.


Regards,
Thomas