D3 Triggers and process information

#1

1) Is there a way for a trigger to know that it is operating against a
table or dictionary?

I have never needed this before and don't know if it is possible. Cant
find anything in the ACCESS() info but thought i would ask.

2) Is there a way to know the process that is causing the change? Is
there a 'call stack' which can be interrogated?

If it makes a difference this is specifically for CALLX but generically
for any of the triggers.

the learning never stops

thanks

dtsig

#2

Access(11) will NEARLY give you want you want .... you may need to have
slightly different versions of trigger for dict/data levels to
differentiate
dtsig wrote:

Quote:

1) Is there a way for a trigger to know that it is operating against a
table or dictionary?

I have never needed this before and don't know if it is possible. Cant
find anything in the ACCESS() info but thought i would ask.

2) Is there a way to know the process that is causing the change? Is
there a 'call stack' which can be interrogated?

If it makes a difference this is specifically for CALLX but generically
for any of the triggers.

the learning never stops

thanks

dtsig

#3

Ross Ferris wrote:

Quote:

Access(11) will NEARLY give you want you want .... you may need to have
slightly different versions of trigger for dict/data levels to
differentiate
dtsig wrote:
1) Is there a way for a trigger to know that it is operating against a
table or dictionary?

I have never needed this before and don't know if it is possible. Cant
find anything in the ACCESS() info but thought i would ask.

2) Is there a way to know the process that is causing the change? Is
there a 'call stack' which can be interrogated?

If it makes a difference this is specifically for CALLX but generically
for any of the triggers.

Thanks ross i will re try

dtsig

#4

Dave:

Yes and Yes. :-)

Bill

"dtsig" <dtsig (AT) hotmail (DOT) com> wrote

Quote:

1) Is there a way for a trigger to know that it is operating against a
table or dictionary?

I have never needed this before and don't know if it is possible. Cant
find anything in the ACCESS() info but thought i would ask.

2) Is there a way to know the process that is causing the change? Is
there a 'call stack' which can be interrogated?

If it makes a difference this is specifically for CALLX but generically
for any of the triggers.

the learning never stops

thanks

dtsig

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

D3 Triggers and process information

comp.databases.pick comp.databases.pick

D3 Triggers and process information - 01-10-2007 , 08:46 AM

Re: D3 Triggers and process information - 01-10-2007 , 05:00 PM

Re: D3 Triggers and process information - 01-10-2007 , 05:08 PM

Re: D3 Triggers and process information - 01-12-2007 , 12:38 AM