Triggers

Hi,

Is there a command which allowse you to check what a
table's trigger is set to in DBC?

TIA,
Pauline

Gregory
Tue Nov 04 05:33:39 CST 2003

Pauline,

? dbgetprop(TableName, 'Table', 'InsertTrigger')
? dbgetprop(TableName, 'Table', 'UpdateTrigger')
? dbgetprop(TableName, 'Table', 'DeleteTrigger')

Gregory
_____________

"Pauline Pearce" <anonymous@discussions.microsoft.com> wrote in message
news:09d401c3a2c3$ff182240$a601280a@phx.gbl...
> Hi,
>
> Is there a command which allowse you to check what a
> table's trigger is set to in DBC?
>
> TIA,
> Pauline

Anders
Tue Nov 04 05:39:11 CST 2003

Hi Pauline

Yes - there are three of them.
DBGETPROP('MyTable','TABLE', 'DeleteTrigger' )
DBGETPROP('MyTable','TABLE', 'InsertTrigger' )
DBGETPROP('MyTable','TABLE', 'UpdateTrigger' )

-Anders

"Pauline Pearce" <anonymous@discussions.microsoft.com> wrote in message
news:09d401c3a2c3$ff182240$a601280a@phx.gbl...
> Hi,
>
> Is there a command which allowse you to check what a
> table's trigger is set to in DBC?
>
> TIA,
> Pauline