Universe triggers

#1

How do I find out which program or process invoked the trigger? I
would like to trap an error condition and report which culprit
perpretrated the offense. I tried @HSTMT but that compiles but
generates an improper data type error at run time.

#2

Try something like:
IF @LOGNAME="ME" THEN DEBUG

Replace ME with your login name and test, test, test.

"denis" <denis.cheltenham (AT) hotmail (DOT) com> wrote

Quote:

How do I find out which program or process invoked the trigger? I
would like to trap an error condition and report which culprit
perpretrated the offense. I tried @HSTMT but that compiles but
generates an improper data type error at run time.

#3

Thanks Albino, but I am trying to catch some rogue program, not some
process which I am running.
Albino Timberwolf wrote:

Quote:

Try something like:
IF @LOGNAME="ME" THEN DEBUG

Replace ME with your login name and test, test, test.

"denis" <denis.cheltenham (AT) hotmail (DOT) com> wrote in message
news:1161218352.665443.101530 (AT) i42g2000cwa (DOT) googlegroups.com...
How do I find out which program or process invoked the trigger? I
would like to trap an error condition and report which culprit
perpretrated the offense. I tried @HSTMT but that compiles but
generates an improper data type error at run time.

#4

denis wrote:

Quote:

How do I find out which program or process invoked the trigger? I
would like to trap an error condition and report which culprit
perpretrated the offense. I tried @HSTMT but that compiles but
generates an improper data type error at run time.

SYSTEM(9001) will give the program tree

#5

denis wrote:

Quote:

How do I find out which program or process invoked the trigger? I
would like to trap an error condition and report which culprit
perpretrated the offense. I tried @HSTMT but that compiles but
generates an improper data type error at run time.

SYSTEM(9001) will give the program tree

#6

denis wrote:

Quote:

How do I find out which program or process invoked the trigger? I
would like to trap an error condition and report which culprit
perpretrated the offense. I tried @HSTMT but that compiles but
generates an improper data type error at run time.

SYSTEM(9001) will give the program tree

#7

denis wrote:

Quote:

How do I find out which program or process invoked the trigger? I
would like to trap an error condition and report which culprit
perpretrated the offense. I tried @HSTMT but that compiles but
generates an improper data type error at run time.

SYSTEM(9001) will give the program tree

#8

Many thanks to Pickie, I was over the moon when I tried it. Thanks
again.
Pickie wrote:

Quote:

denis wrote:
How do I find out which program or process invoked the trigger? I
would like to trap an error condition and report which culprit
perpretrated the offense. I tried @HSTMT but that compiles but
generates an improper data type error at run time.

SYSTEM(9001) will give the program tree

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Universe triggers

comp.databases.pick comp.databases.pick

Universe triggers - 10-18-2006 , 07:39 PM

Re: Universe triggers - 10-19-2006 , 07:14 AM

Re: Universe triggers - 10-19-2006 , 09:09 PM

Re: Universe triggers - 10-23-2006 , 09:30 PM

Re: Universe triggers - 10-23-2006 , 09:30 PM

Re: Universe triggers - 10-23-2006 , 09:30 PM

Re: Universe triggers - 10-23-2006 , 09:30 PM

Re: Universe triggers - 10-25-2006 , 07:04 PM