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.

System.Triggers

2 posts in Trigger Last posting was on 2005-05-10 15:36:21.0Z
Mark Weber Posted on 2005-05-06 16:30:26.0Z
Reply-To: "Mark Weber" <mweber@nationalcorp.com>
From: "Mark Weber" <mweber@nationalcorp.com>
Newsgroups: advantage.trigger
Subject: System.Triggers
Date: Fri, 6 May 2005 11:30:26 -0500
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
NNTP-Posting-Host: 64.215.231.66
Message-ID: <427b9ced@solutions.advantagedatabase.com>
X-Trace: 6 May 2005 10:35:57 -0700, 64.215.231.66
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!64.215.231.66
Xref: solutions.advantagedatabase.com Advantage.Trigger:163
Article PK: 1136231

The application I am writing is to allow users to view the fields, indexes,
stored procedures, views and triggers of our database for various reasons.

This application is written in ASP on IIS.

Logging in as the server's admin, and then connecting to ADS using the admin
account (( ADSSYS )) I run the following:

SELECT * FROM system.triggers WHERE ucase(trig_Tablename) = 'TBLINDEXES'

-OR-

SELECT * FROM system.triggers

I get no records returned.

Running the exact same query(ies) in ADS' Native SQL Utility (CTRL+Q), I do,
in fact, get results.

Selecting from system.[anythingButTriggers] returns results... other than
Triggers.

Any comments?


J.D. Mullin Posted on 2005-05-10 15:36:21.0Z
From: "J.D. Mullin" <no@email.com>
Newsgroups: advantage.trigger
References: <427b9ced@solutions.advantagedatabase.com>
Subject: Re: System.Triggers
Date: Tue, 10 May 2005 09:36:21 -0600
Lines: 10
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
NNTP-Posting-Host: 198.102.102.35
Message-ID: <4280d662@solutions.advantagedatabase.com>
X-Trace: 10 May 2005 09:42:26 -0700, 198.102.102.35
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!198.102.102.35
Xref: solutions.advantagedatabase.com Advantage.Trigger:164
Article PK: 1136233


> Logging in as the server's admin, and then connecting to ADS using the
> admin account (( ADSSYS )) I run the following:

What do you mean by this? Do you mean running it from the asp.net app, or
from other utility?

J.D. Mullin
Advantage R&D