pass parameters to a Trigger?

From: DraguVaso (pietercoucke_at_hotmail.com)
Date: 03/24/04 

Date: Wed, 24 Mar 2004 14:31:43 +0100

Hi,

I have an application with an SQL-database in which I want to put Triggers.

I want to create a Trigger like this:

I do an INSERT to a Table, and the Trigger has to perform an INSERT with
paramters OTHER than the parameters passed by the intial INSERT-statement.
Like for exemple creating somewhere a log with the username of the user
which is working with the application.

Is this possibly? And if yes: how?

Thanks a lot,

Pieter

Relevant Pages

  • pass parameters to a Trigger?
    ... I have an application with an SQL-database in which I want to put Triggers. ... I want to create a Trigger like this: ... Like for exemple creating somewhere a log with the username of the user ... Pieter ...
    (microsoft.public.sqlserver.server)
  • Re: panic: ffs_blkfree: freeing free block
    ... Pieter de Goeje wrote: ... they can no longer trigger it. ... Doing a binary search now. ...
    (freebsd-current)
  • Re: SQL Trigger
    ... tell who is who from using the username() funcions etc. ... accessID but cannot obvously pass that into the trigger as a paramater. ... If their accessid is not held against the row they are trying to edit ...
    (microsoft.public.sqlserver.programming)
  • Re: suser_sname trigger (audit records)
    ... >insert into tblBank ... This trigger will fail. ... with values for the userstamp and username columns only. ... I don't see anything wrong with this trigger. ...
    (microsoft.public.sqlserver.programming)
  • login form to login table
    ... hi, i have a login table with user name and password, and a form that require ... a username and password to trigger another form, i have connected my form to ... vba in access ...
    (microsoft.public.access.forms)