insert trigger problem

From: Andreas Wöckl (woeckl_at_esys.at)
Date: 08/19/04 

Date: Thu, 19 Aug 2004 17:13:14 +0200

hi group!

i have the following problem using an insert trigger on a table with an
identity column as a primary key -> every time i add a value using my form i
get a message that the data can not get displayed -> I know there is the
problem that access is using the @@IDENTITY variable to get the value of the
primary key and with using a trigger this variable gets changed. My Question
is now which workaround can i take? - Is there a possibitity without
changing the pk column?

best regards

andreas wöckl

Relevant Pages

  • Re: insert trigger problem
    ... Is your trigger perfoming an insert onto another table which also has a ... thing your trigger do be: ... "Andreas Wöckl" wrote in message ... > primary key and with using a trigger this variable gets changed. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Help with INSERT TRIGGER - fails with error.
    ... You didn't declare any PRIMARY KEY in this database. ... In an INSERT trigger, ... but I can't get it to work because it references ntext fields. ...
    (comp.databases.ms-sqlserver)
  • Re: Whats wrong with this trigger
    ... the app that uses this data is .NET. ... > same values for the primary key as the ones used in the original tables. ... >>>update trigger that inserts an audit row into a view. ... >>>identity and so is the view that I'm inserting the audit row into. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Concurrency issue
    ... An IDENTITY column is one technique, and perhaps the most simple one. ... only potential downside is that after an INSERT operation you usually end up ... I have also heard of people using random numbers for the primary key column ...
    (microsoft.public.sqlserver.programming)
  • Re: Trigger for updated rows when PK changed
    ... I guess in pure relational theory updating a pk is meaningless - it's always ... Presumably a row-level trigger in something like Oracle would reflect this ... John ... > other than the primary key to uniquely the rows of your table, ...
    (microsoft.public.sqlserver.programming)
Loading