Post reply

Problem with insert trigger and history table

  • September 24, 2005 at 8:48 am

    #89074

    Hello,

    at first - excuse my bad english, but nevertheless i have a problem. 😉 I hope you can help me...

     

    I have a trigger on one table for the insert command. this trigger inserts a record into another table. it works fine for the second table...

    CREATE TRIGGER NeuBugtracking ON [dbo].[ProjekteBugtrackingT]

    FOR INSERT

    AS

     INSERT INTO ProjekteBugtrackingTexteT (BugZahl)

     SELECT (bugid) FROM Inserted

    the problem is that the identity for the first table will not be generated immeadetly...through this specific conduct im getting error messages in the front end app (access 2003). the same happens if i try this in em. the record is updated correct but i can not edit it again till i load the entire recordset again -> wrong identity information.

     

    do you have any idea?

     

    best regards

    andreas

     

  • September 24, 2005 at 9:05 am

    #592849

    andreas - I'm not sure I understand the question - when you insert a new row into your "ProjekteBugtrackingT" table, are you saying that a new "bugID" is not created ?!

    What is the DDL of your "ProjekteBugtrackingT" table ?! Is your "bugID" a primary key - is it an identity column ?! If you provide the DDL & some more details, it would help!







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply