Durby
Thu Jun 30 21:36:22 CDT 2005
Thanks Ander.
this is exactly what i needed. thanks a lot !
"Anders" <anders.altberg@telia.com> wrote in message
news:BEE88255.1603%anders.altberg@telia.com...
> Hi Durby
> Trigger code is triggered by any update, insert or delete action on the
> table, provided it's part of a database. Errors are nothing to do with
> triggers.
> CREATE TRIGGER ON MyTable1 FOR UPDATE AS mytrigger()
> CREATE TRIGGER ON MyTable1 FOR INSERT AS mytrigger()
> CREATE TRIGGER ON MyTable1 FOR DELETE AS mytrigger()
> CREATE TRIGGER ON MyTable2 FOR UPDATE AS mytrigger()
> CREATE TRIGGER ON MyTable2 FOR INSERT AS mytrigger()
> CREATE TRIGGER ON MyTable2 FOR DELETE AS mytrigger()
>
> Put this as a stored procedure in your database
> FUNCTION MyTrigger
> LOCAL, x, y z
> X = ALIAS()
> Y=SYS(0)
> Z=GETFLDSTATE(-1)
> INSERT INTO LOG1 (time, who,tablealias, state) VALUES (DATETIME(),M.x,M.y,
> M.z )
> ENDFUNC
>
> The column state should be a memo if you have to handle tables of widely
> varying number of columns.
>
> The GETFLDSTATE value shows if it's a delete, insert or update. For
> Updates
> it shows which columns were modified.
>
> -Anders
>
>
>
> Den 05-06-29 05.14, i artikeln uNHLliFfFHA.2644@TK2MSFTNGP09.phx.gbl,
> skrev
> "Durby vend" <someone@microsoft.com>:
>
>> trigger will only raise an error, how do you implement
>> in such a way that each transaction made to specific table
>> is being log ?
>>
>>
>> "man-wai chang" <toylet.toylet@gmail.com> wrote in message
>> news:OUdGhr7eFHA.1448@TK2MSFTNGP09.phx.gbl...
>>> Durby vend wrote:
>>>> is there a way to keep a log of all transaction for
>>>> specific table ? (updates that could come from multiple
>>>> modules that performing delete, add and change of data)
>>>
>>> trigger?
>>
>>
>